Course length:  1-day

Course Description

Microsoft’s Office Access is Microsoft’s popular database program.  Microsoft Access is an information management tool that allows you to store, report, and analyze information within a relational database. If you're trying to use Excel to manage large amounts of information, then chances are Microsoft Access will be helpful to you. Access makes it easy to keep track, organize, and sort your data.

This Level 2 class is intended to help those who are familiar with the basics of Access to do more with their database; including managing data in tables, using data management queries, adding controls to forms and formatting reports. The class will also help more experienced users with previous versions of Access to understand the ribbon interface.

Prerequisites

Access Level 1 Foundation or have equivalent knowledge.

Course Outline

Advanced Table Tasks

Managing Data Entry in Tables

Creating Advanced Queries

Formatting Forms

Creating Subforms

Formatting Reports

Certification

Before testing you will need:

  • Access Level 1 Foundation
  • Access Level 2 Intermediate
  • Access Level 3 Advanced

Is Level 2 right for you?

Try our self-assessment