Live Chat
Monday - Friday 8am - 6pm EST Chat Now
Contact Us
Monday - Friday 8am - 8pm EST 1-866-716-6688 Other Contact Options

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:


Access 2016 Level 2 Advanced Database Design

Learn how to use the intermediate-level features of Access 2016 to work with advanced queries, forms, and reports.

GK# 5047

Course Overview


This clinic with hands on labs provides students with the knowledge and skills to become familiar with intermediate-level features and functionality of Microsoft Access 2016.

This course includes access to our exclusive Microsoft Office Online Support Program, enabling you to build your skills and expertise after class. The program provides 24x7 access for 60 days to online mentoring via chat from Microsoft Office experts.


  • Delivery Format:
  • Date:
  • Location:
  • Access Period:


What You'll Learn


After completing this training, students will be able to:

  • Enhance tables by creating lookups
  • Create various types of advanced queries
  • Create advanced forms by adding controls, subforms, calculations, and graphic images
  • Create advanced reports by adding controls, grouping, subforms, calculations, graphic images, and charts
  • Work with and create web-based objects


Viewing outline for:

Classroom Live Outline

Database Overview

  • Database Overview

Enhancing Tables

  • Copying a Database Object
  • Lookup Fields
  • Creating a Lookup

Advanced Queries

  • Query Overview
  • The Query Wizard
  • Nested Queries
  • Query Joins
  • Make Table Queries
  • Append Queries
  • Summary Queries
  • Crosstab Queries

Advanced Forms

  • Form Design
  • Controls
  • Form Properties
  • Subforms
  • Advanced Calculations
  • Customizing Forms

Advanced Reports

  • Designing Reports
  • Sorting and Grouping
  • Layout Properties
  • Calculations
  • Subreports
  • Graphic Reports
  • Chart Wizard

Working with Web Tools

  • Working with Web Pages
  • Hyperlinks



Before attending this clinic, students should have taken Access 2016 Level 1 Database Design or possess an equivalent skillset.

Who Should Attend


This course is intended for participants who are familiar with Microsoft Access and are looking to further develop their ability in managing desktop databases through the use of advanced features.

Follow-On Courses


You can further expand your knowledge of the advanced features and administrative tools within Access 2016 by enrolling in Access 2016 Level 3 Advanced Topics.

Course Delivery

This course is available in the following formats:

Classroom Live

Receive face-to-face instruction at one of our training center locations.

Duration: 1 day

Virtual Classroom Live

Experience expert-led online training from the convenience of your home, office or anywhere with an internet connection.

Duration: 1 day

Request this course in a different delivery format.