Microsoft Access Training

Candid photo of an Asian woman working in an office

Access Courses

We offer 3 levels of Microsoft Access training. Click a course title for more information.

Delivery Options for Microsoft Access Training

There are two ways your team can learn Access. Choose the delivery option that works best for your group.

Online Access Training in Canada or the USA

Everyone on your team can learn Access, online with a live instructor using Microsoft Teams or Zoom.

Online training is available anywhere in Canada or the United States.

Onsite Access Training in Toronto and Ottawa

Our Microsoft Access courses can be delivered onsite, in your organization’s meeting room or training room.

Our service area for onsite training includes Toronto, Mississauga, and Ottawa.

Access Level 1

Training for Access 2016, 2019, and 365

2 day course – $550 per person plus HST. Minimum enrollment required.

Discounted pricing is available for groups of 6 or more, non-profit organizations, and Government of Canada employees.

Course Content

The Basics

Database concepts, getting started, creating a database, converting Access 2016 files, working with objects.

Table Data

Table concepts, viewing data in a table, changing the datasheet appearance, entering and editing data, applying filters.

Table Design

Creating a table, changing the table design.

Data Entry

Data entry concepts, data formats, input masks, input validation, adding records.

Relationships

Relationships between tables, creating a relationship, referential integrity, removing a relationship, printing relationships.

Creating and Using Forms

Creating a form using AutoForm, creating a form using the Form Wizard, creating a form in design view, opening a form, changing a form design, adding controls, placing controls, multiple-choice controls, error checking.

Queries

Using the Query Wizard, creating a query in Design view, selecting and sorting in a query, calculations, action queries, parameter queries.

Reports

Creating reports, using the Report Wizard, previewing reports, creating reports in Design view, changing report design, control operations, control attributes, creating charts.

Importing and Exporting Data

Importing and exporting, importing a text file, importing data from an Access database, exporting data, troubleshooting importing and exporting problems.

Printing

Printing objects, print preview.

▲ Top

Access Level 2

Training for Access 2016, 2019, and 365

Prerequisite: Access Level 1

1 day course – $275 per person plus HST. Minimum enrollment required.

Discounted pricing is available for groups of 6 or more, non-profit organizations, and Government of Canada employees.

Course Content

Database Overview

Database overview.

Enhancing Tables

Copying a database object, lookup fields, creating a lookup.

Advanced Queries

Query overview, the Query Wizard, nested queries, query joins, make table queries, append queries, summary queries, crosstab queries.

Advanced Forms

Form design, controls, form properties, subforms, advanced calculations, customizing forms.

Advanced Reports

Designing reports, sorting and grouping, layout properties, calculations, subreports, graphic reports, chart wizard.

Supplemental Topics: Working with Web Tools

Working with web pages, hyperlinks.

▲ Top

Access Level 3

Training for Access 2016, 2019, and 365

Prerequisite: Access Level 2

1 day course – $275 per person plus HST. Minimum enrollment required.

Discounted pricing is available for groups of 6 or more, non-profit organizations, and Government of Canada employees.

Course Content

Macros

Macro concepts, creating a macro, creating a macro group, opening a macro, running a macro, attaching a macro, macro conditions.

Switchboard

Switchboards overview, creating switchboards, editing a switchboard form.

Customizing Access

Setting Access defaults, customizing the Navigation Pane.

Administrative Functions

Compacting a database, backing up a database, splitting a database, documenting a database.

Database Security

Securing a database, securing a share-level database, Access Trust Center.

▲ Top