Access 2002 (Office XP): Level 2 In this course, you will learn how to enhance your database designs by using the principles of normalization and table relationships. You'll also learn how to query multiple tables for data that is used in customized forms and reports, and how to create data access pages to share data over an intranet or the Internet. In addition, you'll be able to take the guesswork out of creating databases by learning to use data-normalization techniques. See how to take advantage of relational database efficiency to maintain data. You will also learn techniques to save time by controlling data entry and automating tasks. You’ll benefit by becoming familiar with Access features that will enable you to customize forms and reports.
| Lesson 1: Principles of Table Design | |
| Normalizing Data | |
| Normalizing Data for Fourth and Fifth Normal Forms | |
| Lesson 2: Principles of Table Relationships | |
| Analyzing Table Relationships | |
| Establishing and Testing Referential Integrity | |
| Lesson 3: Table Design Techniques | |
| Data Validation Techniques | |
| Subdatasheets and Lookup List Fields | |
| Indexing Techniques | |
| Lesson 4: Designing Select Queries | |
| Using Calculated Fields in Queries | |
| Creating Multiple Table Queries | |
| Lesson 5: Parameter and Action Queries | |
| Creating Parameter Queries | |
| Creating Action Queries | |
| Lesson 6: Customizing Form Designs | |
| Customizing the Form Design | |
| Performing Calculations on a Form | |
| Adding Combo Boxes to a Form | |
| Adding Unbound Controls to a Form | |
| Lesson 7: Working with Data Access Pages | |
| Creating and Modifying Data Access Pages | |
| Integrating with Other Applications | |
| Lesson 8: Customizing Reports | |
| Customizing a Report Created by the Report Wizard | |
| Creating a Report in Design View | |