Access Level 2

Audience:

This course is designed for students wishing to gain intermediate-level skills or individuals whose job responsibilities include constructing relational databases, performing database maintenance, or creating advanced queries and reports.

Prerequisites:

The course assumes you have completed Access Level 1, or you have equivalent skills in using Access.

Description:

This course provides the concepts and skills for the advanced use of Microsoft Access. This includes how to create advanced queries, forms, and reports, how to create macros, and how to manage your databases.

Outline:

Chapter 1: Advanced Queries

• Module A: Grouping and summarizing
• Module B: Updating, deleting, and relationships
• Module C: Indexing for performance

Chapter 2: Advanced forms

• Module A: Subforms 
• Module B: Advanced control types
• Module C: Specialized form types

Chapter 3: Advanced reports

• Module A: Subreports 
• Module B: Advanced grouping
• Module C: Advanced formatting 

Chapter 4: Macros

• Module A: Creating basic macros
• Module B: Using variables
• Module C: Troubleshooting macros

Chapter 5: Database Management

• Module A: Compact & Repair
• Module B: Restoring a database
• Module C: Other maintenance tasks