This course is designed for individuals interested in learning the skills necessary to manage data, including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data in Microsoft® Office Access® 2013. 


This course helps individuals prepare for the Access 2013 Microsoft Office Specialist (MOS) Certification exam.

Upon successful completion of this course, participants will be able to:

  • Navigate within the Microsoft Access application environment and create a simple database.
  • Organize and manage data stored within Access tables.
  • Use queries to join, sort, and filter data from different tables.
  • Create advanced queries, including action queries and parameter queries.
  • Create and format custom reports.
  • Customize Access configuration options.

To ensure success, participants will need to be familiar with using personal computers, should have experience using a keyboard and mouse, and be familiar with Microsoft® Office Windows® user interface.

Suggested Class SizeMinimum 3
Maximum 12
Course LengthFull day
Table of Contents

Lesson 1: Getting Started with Access

Topic A: Orientation to Microsoft Access

Topic B: Create a Simple Access Database

Topic C: Get Help in Microsoft Access


Lesson 2: Working with Table Data

Topic A: Modify Table Data

Topic B: Sort and Filter Records

Topic C: Create Lookups


Lesson 3: Querying a Database

Topic A: Join Data from Different Tables in a Query

Topic B: Sort and Filter Data in a Query

Topic C: Perform Calculations in a Query


Lesson 4: Creating Advanced Queries

Topic A: Create Parameter Queries

Topic B: Create Action Queries

Topic C: Create Unmatched and Duplicate Queries

Topic D: Summarize Data


Lesson 5: Generating Reports

Topic A: Create a Report

Topic B: Add Controls to a Report

Topic C: Enhance the Appearance of a Report

Topic D: Prepare a Report for Print


Lesson 6: Customizing the Access Environment

Topic A: The Access Options Dialog Box