Access - Level Two

This class is for those people who need to refine their skills in Access. Covered topics include normalizing tables, table relationships and integrity, data validation and indexing. Multiple-table queries, enhanced form design and custom reports are also covered.

Participants should be experienced computer users and must have completed Access Level One.

Module 1: Principles of Table Design

• Normalizing data
• Junction tables and foreign keys

Module 2: Principles of Table Relationships

• Analyzing table relationships
• Establishing and testing referential integrity

Module 3: Table Design Techniques

• Data validation techniques
• Indexing techniques

Module 4: Designing Select Queries

• Working with calculations
• Creating multiple-table queries

Module 5: Enhanced Form Design

• Customizing the form design
• Adding calculations to a form
• Adding combo boxes
• Sub-forms

Module 6: Customizing Reports

• Customizing reports created by the Report Wizard
• Sub-reports