Coronavirus (COVID-19) information: Live classes available in-person or online from our fully vaccinated instructors. Learn more about our reopening.


Microsoft Access Bootcamp

Microsoft Access Bootcamp

Learn foundational through intermediate Microsoft Access skills in this Access Bootcamp training. This two-day course starts with the essentials of Access and relational databases then moves into intermediate skills such as joining tables, improving data structure, validating data, and conducting advanced queries, .

In this two-day Access Bootcamp start by learning to create a new database, design forms, build tables, and generate reports. Also learn to filter data, sort data, manage data sets and conduct advanced queries. Learn efficient use of Microsoft Access to create, store, and report on sets of data.

Questions about this Microsoft Access Bootcamp? Interested in a private or customized training? Call to speak with a training consultant: 781-376-6044.

Microsoft Access Bootcamp Course Dates

All classes are led by a live instructor. Class times listed are Eastern time.


Please call 800-851-9237 or 781-376-6044 to schedule a course.

Contact AGI to request course dates.

Access Training Course - Introduction: Complete Class Topics

Access Fundamentals

  • Orientation to Microsoft Access
  • Create a Simple Access Database
  • Configuring Options in Microsoft Access
  • Understanding the Help options

Working with Table Data in Access

  • Modifying Table Data
  • Sorting Records
  • Filtering Records

Querying an Access Database

  • Create Basic Queries in Access
  • Sorting Data in a Query
  • Filtering Data in Query
  • Perform Calculations as part of a Query

Creating and Using Access Forms

  • Creating Forms using Access
  • Work with Data in Access Forms

Generating Reports

  • Create a Report
  • Add Controls to a Report
  • Enhance the Appearance of a Report
  • Prepare a Report for Print
  • Organize Report Information
  • Format Reports

Designing Relational Databases

  • Fundamentals of Relational Database Design
  • Creating Tables
  • Creating Table Relationships

Joining Tables in Access

  • Creating Query Joins
  • Relating Data Within a Table
  • Working with Subdata sheets

Using Access Data Validation

  • Validating Fields
  • Using options for Form and Record Validation

Creating Advanced Queries in Access

  • Creating Parameter Queries
  • Summarizing Data
  • Creating Subqueries
  • Creating Action Queries
  • Creating Unmatched and Duplicate Queries

Organizing an Access Database for Efficiency

  • Data Normalization
  • Create Junction Tables
  • Improving Table Structure

Using Advanced Reporting Techniques in Access

  • Including Control Formatting in Reports
  • Adding Calculated Fields to Reports
  • Add a Subreport to Existing Reports

We recommend that you have Access installed on your computer before starting this class.

You will receive a comprehensive course manual for this Access class developed by the instructors at AGI. AGI instructors have created many of the official training guides and books for Microsoft.

Available Delivery Methods For This Class