Microsoft Access 2003 Level 2
Principles of table design
Normalizing data
Normalizing data for fourth and fifth normal forms
Principles of table relationships
Analyzing table relationships
Establishing and testing referential integrity
Table design techniques
Data validation techniques
Indexing techniques
Designing select queries
Using calculated fields in queries
Creating multiple-table queries
Customizing form designs
Customizing the form design
Performing calculations on a form
Adding combo boxes to a form
Adding unbound controls
Working with data access pages
Creating data access pages
Customizing reports
Customizing a report created by the Report Wizard
Working with subreports
Class Information
Duration: 1 day
Prerequisite: Microsoft Access 2003 Level 1 or equivalent experience.
Course Materials: Course manual (074461S3)
Description: Students will learn to enhance their database designs by using the principles of data normalization and table relationships; to query multiple tables for data that is used in customized forms and reports; and to begin using data access pages.
Student Comments
Great class! Instructor very professional and knowledgeable.
—Access, Level 1