Sayers & Associates - Access 2000

		Course Description
		ACCESS 2000 - LEVEL 2

		Course Length	1 Day - 8 Hour Class Session
		Overview	Students will learn how to enhance their database designs by using the principles of normalization and table relationships. Students also learn how to query multiple tables for data that is used in customized forms and reports. Additionally, students learn how to create data access pages to share data over an intranet or the Internet
		Prerequisite	Introduction to Personal Computers Window 2000 Introduction or Windows XP Introduction Word 2000 Level 1 Word 2000 Level 2 Word 2000 Level 3 Excel 2000 Level 1 Excel 2000 Level 2 Excel 2000 Level 3 Access 2000 Level 1
		Delivery Method	Instructor-Led, Group Paced, Classroom-Delivery Learning Model with Structured Hands-On Activities
		Benefits	Students will learn how to take the guesswork out of creating databases by using data-normalization techniques. They will learn how to take advantage of relational database efficiency to maintain data. In addition, students will be able to save time by controlling data entry and automating tasks. Students will also benefit by becoming familiar with Access features that will enable them to customize forms and reports, and to share data over an intranet or the Internet by creating and using data access pages
		Target Student	Students enrolling in this course should understand the basics of creating and using database objects, including tables, queries, forms, and reports
		What's Next	Access 2000: Level 3 Advanced In this course, students learn to create advanced queries, create more efficient forms and reports and work with macros. Access 2000: Level 4- Introduction to Application Design Students learn to create custom applications students to create custom applications.
		Objectives	Normalize sample tables by identifying design problems. Establish relationships between tables by analyzing table relationships and enforcing referential integrity. Customize table designs by setting field properties to maintain data integrity, by creating a lookup list, and by creating indexes. Design select queries by using multiple tables to calculate, group, average, and concatenate values and to show top values. Customize form designs by creating calculated fields, combo boxes, and unbound controls. Interact with data through a browser by creating and using data access pages. Customize report designs by grouping, sorting, and summarizing data, and by adding subreports.
			Please Contact Us For Class Outlines.