Registration and Payment Deadline Extended - New Date January 23
AudienceThis 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.

DescriptionUpon 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.

PrerequisitesTo 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 ContentsLesson 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