Schedule your class   Schedule >

Access Intermediate (Level 2)

Course length:  1-day

Exercise Files

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.


This course is delivered using Access 2016. With the exception of the new modern look and touch screen support, there are few differences between the Office suites; therefore, users currently operating on Office 2010 and later will benefit from the material in this course.



It is recommended that you have completed Access Foundation (Level 1) or have equivalent knowledge.

Course Outline


Advanced Table Tasks

In this module, students are shown how to insert application parts, use the Table Analyzer Wizard, create validation rules, and configure validation messages.

  • Inserting Application Parts
  • Using the Table Analyzer Wizard
  • Creating Validation Rules
  • Configuring Validation Messages

Managing Data Entry in Tables

Students will learn how to set properties to table fields to streamline data. Topics include how to mark fields as required, mark a field for indexing, create lookup fields, create value lists, and create input masks.

  • Marking Fields as Required
  • Marking a Field for Indexing
  • Creating Lookup Fields
  • Creating Value Lists
  • Creating Input Masks

Creating Advanced Queries

Getting a more in-depth look at queries is the goal of this module. Students will learn how to use parameter queries to prompt users for criteria without having to enter design view and management queries perform actions on the data in tables.

  • Creating and Using Parameter Queries
  • Creating and Using Crosstab Queries
  • Creating and Using Make-Table Queries
  • Creating and Using Multiple Table Queries
  • Creating and Using Append Queries
  • Creating and Using Delete Queries
  • Creating and Using Update Queries


Formatting Forms

Students will learn how to create forms in design view without the help of a wizard, and add fields, controls and images to a form to improve appearance and navigation.

  • Creating a Form from Scratch
  • Understanding Bound and Unbound Controls
  • Changing the Theme
  • Using the Format Painter
  • Adding Fields
  • Adding Controls
  • Adding Images and Logos

Creating Subforms

This module covers how to create and use subforms, link subforms with parent forms, and format a subform within a main form.

  • Creating Subforms
  • Using Subforms
  • Linking Subforms with Parent Forms
  • Formatting a Subform within a Main Form

Formatting Reports

Information on reports is continued here with a look at how to create a report without help from a Wizard, improve formatting, and group and sort data in reports and add controls, images, logos, page numbers, headers, and footers.

  • Creating a Report from Scratch
  • Changing the Theme
  • Using the Format Painter
  • Grouping and Sorting Data
  • Adding Controls
  • Adding Images and Logos
  • Adding Page Numbers, Headers, and Footers

Schedule your class   Schedule >