Microsoft Access (MOS Access Associate)

Objective: To master database design, creation, and data extraction.

Access Basics:
Database concepts (tables, relationships, forms, queries, reports).
Creating a new database.
User interface.
Creating tables:
Designing tables and fields (field types, primary keys).
Entering and editing data.

Working with Relationships:
Creating relationships between tables (One-to-Many, Many-to-Many).
Enforcing Referential Integrity.
Queries:
Creating simple select queries.
Using criteria.
Creating calculated fields.

Forms:
Create forms for data entry.
Customize forms.
Reports:
Create reports to display data.
Format reports.