Welcome to ONLC Training Centers
Welcome to ONLC Training Centers

Access 2013 Advanced Course Outline

 (2 days)
Version 2013

*** WARNING: High Volume Class, Sign Up Early ***
This is one of our most popular classes. A green flag beside a date on the right means that a session has met the minimum enrollment levels and is running. However, it is common for dates for this course to fill several weeks in advance. Even if a date has a green flag, you might not be able to get into that session if it is full. To avoid disappointment, it is best to register for this class at least three weeks in advance.

Your training and experience using Microsoft® Access® 2013 has given you basic database management skills such as creating tables, designing forms and reports, and building queries. In this course, you will expand your knowledge of relational database design, write advanced queries, structure existing data, share data across applications, and customize reports. Extending your knowledge of Microsoft Access 2013 will result in a robust, functional database for your users.

You can also use this course to prepare for the Microsoft Office Specialist (MOS) Certification exams for Microsoft Access 2013.

Target Student
This course is designed for students wishing to gain intermediate-level skills or individuals whose job responsibilities include constructing relational databases, performing database maintenance, creating advanced queries and reports, or integrating Access with other programs.

To ensure your success, it is recommended you have completed Access® 2013 Introduction, or possess equivalent knowledge.

Course Content

Lesson 1: Organizing a Database for Efficiency
Topic A: Data Normalization
Topic B: Create a Junction Table
Topic C: Improve Table Structure

Lesson 2: Joining Tables
Topic A: Create Query Joins
Topic B: Join Tables That Have No Common Fields
Topic C: Relate Data within a Table
Topic D: Work with Subdatasheets
Topic E: Create Subqueries

Lesson 3: Advanced Reporting
Topic A: Organize Report Information
Topic B: Format Reports
Topic C: Include Control Formatting in a Report
Topic D: Add a Calculated Field to a Report
Topic E: Add a Subreport to an Existing Report

Lesson 4: Implementing Advanced Form Design
Topic A: Add Controls to Forms
Topic B: Create Subforms
Topic C: Organize Information with Tab Pages
Topic D: Enhance Navigation of Forms
Topic E: Apply Conditional Formatting

Lesson 5: Using Data Validation
Topic A: Field and Record Validation
Topic B: Form Validation

Lesson 6: Using Macros to Improve User Interface Design
Topic A: Create a Macro
Topic B: Restrict Records Using a Condition
Topic C: Validate Data Using a Macro
Topic D: Automate Data Entry Using a Macro
Topic E: Convert a Macro to VBA

Lesson 7: Using Advanced Database Management
Topic A: Link Tables to External Data Sources
Topic B: Manage a Database
Topic C: Determine Object Dependency
Topic D: Document a Database
Topic E: Analyze the Performance of a Database

Lesson 8: Managing Switchboards
Topic A: Create a Database Switchboard
Topic B: Modify a Database Switchboard
Topic C: Set Startup Options

Level 2 - Appendix A: Additional Reporting Options

View outline in Word


Attend hands-on, instructor-led Access 2013 Advanced training classes at ONLC's more than 300 locations. Not near one of our locations? Attend these same live classes from your home/office PC via our Remote Classroom Instruction (RCI) technology.

For additional training options, check out our list of Access Courses and select the one that's right for you.

Microsoft Gold Partner
Class Dates
(click date for class times)
(click Enroll for locations)
More dates...

Fee:  $695

Savings options:

 CEA Apps Saver
Need a price quote?

Follow the link to our self-service price quote form to generate an email with a price quote.

Email Alert

Receive an email when this class is available as "Ready to Run" or "Early Notice" status.

Attend from your office or home

If you have high-speed internet and two computers you can likely take this class from your office or home.

Need a class for a group?

We can deliver this class for a private group at your location. Follow the link to request more information.

Attend computer classes from ONLC Training Centers Request a copy via mail


Class Format
Class Policies
Student Reviews

Bookmark and Share

First Name

Last Name