Access 2000 Level 2

Description

Students will learn how to take the guesswork out of creating databases by using data normalization techniques; save time by controlling data entry and automating tasks; customize forms and reports. This course meets Microsoft Proficiency Certification Guidelines.

Outcome Summary

Participant will be able to:

• Normalize sample tables by identifying design problems (NACFAM CU 7)
• 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 concentrate values and show top values
• Customize form designs by creating calculated fields, combo boxes and unbound controls
• Display table information that has a one-to-many relationship by creating forms that contain subforms
• Customize report designs by grouping, sorting, and summarizing data, and by adding subreports
• Interact with data through a browser by creating and using data access pages

Who Should Attend

Individuals who want to learn Access features and techniques that will enable them to enhance their database designs and enforce database integrity, create custom forms and reports, and work with advanced queries and table relationships.

Length

7 hours

Prerequisites

Participants in this course should have working experience with Windows 98, and be comfortable working with a personal computer. Previous working experience with Access 2000 is required.

Learning Environment

Instructor-led/group-paced class with structured hands-on learning activities.

Maximum/Minimum Enrollment

10/3

Catalog Number

MICR 207