Microsoft Access 2003 Level 2
| Duration: | 1 day |
| Prerequisite: | Microsoft Access 2003 Level 1 or equivalent experience. |
| Course Materials: | Course manual (074461S3) |
| Prices: | $195 for 1 student (one-on-one training) $160 each for 2 to 3 students $130 each for 4 to 6 students $130 for the first 6 students, $100 for each additional student |
| 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. |
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