Access XP/2003 Level 2

Overview: 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 are used in customized forms and reports.

Prerequisites: Access Level 1 or equivalent knowledge.

Course Outline

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
Indexing techniques

Lesson 4: Designing select queries

Working with calculations
Creating multiple-table queries

Lesson 5: Enhanced form design

Customizing the form design
Adding calculations to a form
Adding combo boxes to a form
Adding unbound controls

Lesson 6: Subform design

Creating a form that contains a subform
Using the Form Wizard to create a form that contains a subform

Lesson 7: Customizing reports

Customizing a report created by the Report Wizard
Subreports

Appendix A: Using the Chart Wizard

Appendix B: Mailing labels