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.
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.
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.