Microsoft Access 2000 Level 2
| Duration: | 1 day |
| Prerequisite: | Microsoft Access 2000 Level 1 or equivalent experience |
| Course Materials: | Course manual (074401S3) |
| 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 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. |
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