Toll Free - 877-442-3915

Account | Self-Paced Login

Account | Self-Paced Login | 877-442-3915

Access Advanced Training Course

Access Advanced Training Course


Course Description: : Thie Microsoft Access 2016 Advanced course will expand upon the topics covered in the Access 2016 Introduction course, including teaching relational database design, writing advanced queries, structuring existing data, sharing data across applications, and customizing reports. lease note: This class taught using the Access 2016 version and is for users of Access 2016, 2013 and 2010. There are very few differences between the versions, and the instructor will highlight any differences.

Upon completion of the course, users will be able to:

  • Efficiently organize a database
  • Join tables
  • Perform advanced reporting
  • Implement advanced form design
  • Use data validation
  • Use macros to improve user interface design
  • Use advanced database management
  • Managing switchboards

Training Dates
(Click on the course name below to view course details and full list of class dates)

Access Advanced
Locations: Available Nationwide and Online
Class Date(s): 9/30/2020 - 10/1/2020
Course Fee : $695


Access Advanced
Locations: Available Nationwide and Online
Class Date(s): 10/15/2020 - 10/16/2020
Course Fee : $695


Access Advanced
Locations: Available Nationwide and Online
Class Date(s): 10/28/2020 - 10/29/2020
Course Fee : $695


Access Advanced
Locations: Available Nationwide and Online
Class Date(s): 11/12/2020 - 11/13/2020
Course Fee : $695


Access Advanced
Locations: Available Nationwide and Online
Class Date(s): 11/30/2020 - 12/1/2020
Course Fee : $695


Access Advanced
Locations: Available Nationwide and Online
Class Date(s): 12/10/2020 - 12/11/2020
Course Fee : $695


Access Advanced
Locations: Available Nationwide and Online
Class Date(s): 12/28/2020 - 12/29/2020
Course Fee : $695


Access Advanced
Locations: Available Nationwide and Online
Class Date(s): 1/7/2021 - 1/8/2021
Course Fee : $695


Access Advanced
Locations: Available Nationwide and Online
Class Date(s): 1/20/2021 - 1/21/2021
Course Fee : $695


Access Advanced
Locations: Available Nationwide and Online
Class Date(s): 2/4/2021 - 2/5/2021
Course Fee : $695


Access Advanced
Locations: Available Nationwide and Online
Class Date(s): 2/18/2021 - 2/19/2021
Course Fee : $695


Access Advanced
Locations: Available Nationwide and Online
Class Date(s): 3/3/2021 - 3/4/2021
Course Fee : $695


Access Advanced
Locations: Available Nationwide and Online
Class Date(s): 3/18/2021 - 3/19/2021
Course Fee : $695


Access Advanced
Locations: Available Nationwide and Online
Class Date(s): 3/31/2021 - 4/1/2021
Course Fee : $695


Access Advanced
Locations: Available Nationwide and Online
Class Date(s): 4/15/2021 - 4/16/2021
Course Fee : $695


Access Advanced
Locations: Available Nationwide and Online
Class Date(s): 4/28/2021 - 4/29/2021
Course Fee : $695


Course Syllabus

Course Content

Section 1: Organizing a Database for Efficiency
Topic 1: Data Normalization
Topic 2: Creating a Junction Table
Topic 3: Improve Table Structure

Section 2: Joining Tables
Topic 1: Creating Query Joins
Topic 2: Relating Data Within a Table
Topic 3: Working with Subdatasheets

Section 3: Creating Advanced Queries in Access 2016
Topic 1: Creating Parameter Queries
Topic 2: Summarizing Data
Topic 3: Creating Subqueries
Topic 4: Creating Action Queries
Topic 5: Creating Unmatched and Duplicate Queries

Section 4: Using Advanced Reporting Techniques
Topic 1: Including Control Formatting in a Report
Topic 2: Adding a Calculated Field to a Report
Topic 3: Adding a Subreport to an Existing Report

Section 5: Implementing Advanced Form Design
Topic 1: Adding Controls to Forms
Topic 2: Enhancing Navigation and Organization of Forms
Topic 3: Applying Conditional Formatting

Section 6: Using Data Validation
Topic 1: Using Field Validation
Topic 2: Using Form and Record Validation

Section 7: Using Macros to Improve User Interface Design
Topic 1: Creating a Macro
Topic 2: Restricting Records Using a Condition
Topic 3: Validating Data Using a Macro
Topic 4: Automating Data Entry Using a Macro

Section 8: Managing Switchboards
Topic 1: Creating a Database Switchboard
Topic 2: Modify a Database Switchboard
Topic 3: Set Startup Options

Section 9: Using Advanced Database Management
Topic 1: Managing a Database
Topic 2: Determining Object Dependency
Topic 3: Documenting a Database

Onsite access Training
Small Group Package (up to 6 students)
  • A Professional Instructor will come to your office and train your students
  • Up to 6 students can attend the class for the flat rate course price of $1800/day
  • Additional students can be added for $125/person/day
  • Each student receives a Course Manual with Practice Files (Materials will be shipped before the class date)
  • Course is scheduled based on dates you provide (Subject to instructor availability)
  • We usually require about 2-weeks lead time to arrange a training session
  • Training is completed in a convenient 1-day session (Start at 9am and Finish at 4:30pm)
  • Two 15 minute breaks and one hour long break for lunch

Total Cost for 6 students: $1800/day (Flat Rate)

Medium Group Package (up to 12 students)
  • A Professional Instructor will come to your office and train your students
  • Up to 12 students can attend the class for the flat rate course price of $2500/day (over 31% off our Individual Training rates)
  • Additional students can be added for $100/person/day
  • Each student receives a Course Manual with Practice Files (Materials will be shipped before the class date)
  • Course is scheduled based on dates you provide (Subject to instructor availability)
  • We usually require about 2-weeks lead time to arrange a training session
  • Training is completed in a convenient 1-day session (Start at 9am and Finish at 4:30pm)
  • Two 15 minute breaks and one hour long break for lunch

Total Cost for 12 students: $2500/day (Flat Rate)

Large Group Package (up to 18 students)
  • A Professional Instructor will come to your office and train your students
  • Up to 18 students can attend the class for the flat rate course price of $3100 (over 43% off our Individual Training rates)
  • Additional students can be added for $75/person/day
  • Each student receives a Course Manual with Practice Files (Materials will be shipped before the class date)
  • Course is scheduled based on dates you provide (Subject to instructor availability)
  • We usually require about 2-weeks lead time to arrange a training session
  • Training is completed in a convenient 1-day session (Start at 9am and Finish at 4:30pm)
  • Two 15 minute breaks and one hour long break for lunch

Total Cost for 18 students: $3100/day (Flat Rate)




Online Self-Paced Training Value Package Only $149

"The Instructor made class truly interesting and put everything into real world terms."
- Meredith T(Jersey City, NJ)


Business Computer Skills Microsoft Partner

Featured Content

Ultimate Guide to Excel Charts and Graphs

Business Computer Skills BBB Profile