MSA-201: Microsoft Access Level 2

Overview:
This one-day course provides students with the principles of normalization, table relationships, and referential integrity and how to query multiple tables for data that is used in customized forms, reports and subreports.

Prerequisites:
Prior to attending this class, students should have the following experience:

• Understanding of the basic concepts involved in working with a personal computer (PC)
• Familiarity with the Windows interface
• Microsoft Access - Level 1, or equivalent knowledge

Objectives:
Upon successful completion of this course, students should be able to:

• Normalize tables through fifth normal form.
• Establish relationships between tables and enforce referential integrity.
• Maintain data integrity in tables by setting properties, creating a Lookup list, and creating indexes.
• Use queries to calculate expressions and extract data from multiple tables.
• Improve form designs by adding bound controls, calculated fields, and combo boxes.
• Create and modify data access pages, and integrate data with other applications.
• Create and modify reports with the Report Wizard and Design View, add a subreport, and add a calculated control.

Modules:

1. Principles of Table Design
2. Principles of Table Relationships
3. Table Design Techniques
4. Designing Select Queries
5. Customizing Form Designs
6. Working with Data Access Pages
7. Customizing Reports

r