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:


Microsoft Access 2013 Level 2 - Advanced Database Design

Learn the advanced features and functionality of Microsoft Access 2013.

GK# 7784

Course Overview


This course with hands on labs provides you with the knowledge and skills to become familiar with intermediate features and functionality relating to Microsoft Access 2013.

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.


This course is one of four recommended to help you prepare for Microsoft Exam 77-424: Access 2013, which is required for the Microsoft Office Specialist (MOS): Microsoft Office Access 2013 certification.


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


What You'll Learn

  • 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

1. Database Overview

  • Database Overview

2. Enhancing Tables

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

3. Advanced Queries

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

4. Advanced Forms

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

5. Advanced Reports

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

6. Supplemental Topics: Working with Web Tools

  • Working with Web Pages
  • Hyperlinks



Who Should Attend


This course is intended for participants who are familiar with Microsoft Access 2013 and want to learn advanced design elements in the common database objects.

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

Request this course in a different delivery format.