Register Now      202-747-5000
Road Map To Learning

Choose Your Learning Adventure:

Select from our standard “off-the-shelf” classes or build a course to target your learning goals. Ready to learn new skills? Contact Softek today!

Advanced Microsoft Access

1 Day, 9:00-4:00

Course Overview

This instructor-led course, through lecture and hands-on exploration, will teach students the skills needed to create complex queries to validate and analyze data, add advanced elements to existing forms and reports, and work with features that automate the database and allow for multi-user access. This course is geared for users who are comfortable creating basic tables, forms, queries, and reports.

Course Objectives

  • Create advanced queries that generates crosstabs, find duplicates, and unions data
  • Customize subforms and add tab controls to layer data
  • Adjust report sources and add on-the-fly print titles
  • Create macros to run commands via a button
  • Create a main menu that allows users to easily navigate through database functions
  • Understand best practices for working with a shared database

Course Outline

Creating Queries to Validate and Analyze Data

  • Creating Crosstab Queries
  • Editing Crosstab Queries
  • Creating Crosstabs Using Dates
  • Finding Duplicate Records
  • Finding Matches and Non-Matches Between Tables
  • Creating Union Queries

Adding Advanced Form Elements

  • Changing the View of Subforms
  • Working with Tab Controls
  • Adding Tab Controls
  • Adding or Moving Fields into Tab Controls
  • Resizing Tab Controls
  • Modifying the Caption Property
  • Inserting and Deleting Page Tabs
  • Changing the Order of Page Tabs
  • Saving Forms as Reports

Adding Advanced Report Elements

  • Changing the Record Source of Objects
  • Including Parameters in Report Titles

Creating Basic Macros

  • Creating Macros to Preview Reports from Forms
  • Attaching Macros to Command Buttons
  • Running Macros

Creating a Switchboard or Main Menu

  • Creating Main Menu Switchboards
  • Adding Items to Switchboards
  • Opening Switchboards
  • Creating Additional Switchboards
  • Navigating Between Switchboards
  • Viewing Switchboard Items
  • Displaying Switchboards on Startup

Sharing and Maintaining a Database

  • Sharing Databases on a Network
  • Refraining from Design Changes
  • Finding Out if Other Users are in the Database
  • Opening Databases in Exclusive Mode
  • Setting Database Passwords
  • Linking Tables Between Databases
  • Compacting and Repairing Databases
  • Using the Back Up Database Feature
  • Printing Database Object Information

Cost and Delivery Format Options

We offer the above listed class on our public schedule and as a private group class in the following delivery formats:

Public Class: Live Virtual
Per student $325
Private Group Class: Live Virtual
1-4 students $700
5-8 students $850
9-12 students* $950
*$50 per additional student
Private Group Class: At Your Location
1-4 students $950
5-8 students $1100
9-12 students* $1200
*$50 per additional student

Private Group Training

Private group classes are cost effective when you have a group of students who need the same course. Volume discounts of 5% to 20% are available when five or more training days are scheduled. For classes conducted at your location, you are responsible for the classroom setup which should include:

  • A computer for each student (with the appropriate software installed), and
  • An instructor workstation connected to a visual display (e.g., projector, smartboard, etc.).


Softek can easily customize a training course that covers the specific topics you require and integrate examples relevant to your work environment. Course customization is billed at $150 per hour and covers time needed to meet, discuss, prepare, and incorporate any specific examples into the training program. Once we have a better idea of what you have in mind, we will be glad to provide a specific price quote for the customization.

Why Choose Softek?

  • Live, virtual or in-person training
  • Instructors with 15+ years of experience
  • Detailed training guide
  • Certificate of completion
  • Money-back guarantee