Microsoft Access Training

Courses in Toronto, Mississauga, St. Catharines, and Ottawa

Microsoft Access Training

Access 2016 Level 1
2 days, $550 / participant
More Info
Access 2016 Level 2
1 day, $275 / participant
More Info
Access 2016 Level 3
1 day, $275 / participant
More Info

Training is available for Access 2010, 2013, and 2016. Discounted pricing offered for groups of 6 or more. Minimum enrollment required. Courses are delivered onsite in Toronto, Mississauga, St. Catharines, and Ottawa.

Request a Quote!

Onsite Microsoft Access Training

No travel expenses, no hassle. Just quality Microsoft Access training delivered in your company’s meeting room.

Live Instructors

Training from subject matter experts. Ask questions, get answers. Microsoft Access training that’s way better than eLearning!

Focused and Relevant

Courses with an emphasis on the skills you need. “Hands on” exercises with plenty of time to review.

Microsoft Access Training for Your Team!

Microsoft Access is a relational database designed to help your team track, manage, and report on large data sets. Whether you want to work with an inventory, track customer interactions, or build a repository of project data, this powerful application is up to the task! Our Microsoft Access training is designed to help your group build databases for a broad range of applications.

Access is a registered trademark of Microsoft Corporation. Visit the Office website for more information.

We offer 3 levels of Microsoft Access training:

Access 2016 Level 1

2 Day Course. $550 / participant plus HST.

Back to Course List Request a Quote!

Minimum enrollment required. Discounted pricing available for groups of 6 or more. Courses offered for Access 2010, 2013, and 2016. All training delivered onsite, in your company’s meeting room.

Intended Audience

This course is designed for new Access users or anyone that needs to learn how to build and manage databases.

Prerequisites

General proficiency with Microsoft Windows

Agenda

Lesson 1: The Basics

  • An overview of database concepts
  • Creating databases
  • Working with database objects

Lesson 2: Table Data

  • An overview of table concepts
  • Working with tables in datasheet view
  • Data entry and editing
  • Using filters

Lesson 3: Table Design

  • Creating tables
  • Working with tables in design view

Lesson 4: Data Entry

  • An overview of data entry concepts
  • Using field properties to enhance accuracy

Lesson 5: Relationships

  • Understanding relationships
  • Creating and managing relationships
  • Utilizing referential integrity

Lesson 6: Creating and Using Forms

  • Creating forms
  • Working with forms in design view
  • Utilizing controls to simplify data entry

Lesson 7: Queries

  • Creating queries
  • Selecting and sorting query results
  • Performing calculations using queries
  • Modifying data using action queries
  • Customized searches using parameter queries

Lesson 8: Reports

  • Creating reports
  • Customizing reports in design view
  • Previewing and printing reports

Lesson 9: Importing and Exporting Data

  • Import and export data using various formats

Lesson 10: Printing

  • Previewing and printing various Access objects

Access 2016 Level 2

1 Day Course. $275 / participant plus HST.

Back to Course List Request a Quote!

Minimum enrollment required. Discounted pricing available for groups of 6 or more. Courses offered for Access 2010, 2013, and 2016. All training delivered onsite, in your company’s meeting room.

Intended Audience

This course is designed for experienced Access users who work with sophisticated databases.

Prerequisites

Access 2013 Level 1

Agenda

Lesson 1: Database Overview

  • Overview of database used in the course
  • Review of key database design concepts

Lesson 2: Enhancing Tables

  • Duplicating database objects
  • Adding lookup fields to a table

Lesson 3: Advanced Queries

  • Building nested queries
  • Working with query joins
  • Utilizing make table and append queries
  • Summary and crosstab queries

Lesson 4: Advanced Forms

  • Utilizing controls and properties
  • Working with subforms
  • Performing advanced calculations

Lesson 5: Advanced Reports

  • Sorting and grouping settings
  • Utilizing summary calculations
  • Working with subreports
  • Adding charts and graphics

Lesson 6: Working with Web Tools

  • Working with hyperlinks and web pages

Access 2016 Level 3

1 Day Course. $275 / participant plus HST.

Back to Course List Request a Quote!

Minimum enrollment required. Discounted pricing available for groups of 6 or more. Courses offered for Access 2010, 2013, and 2016. All training delivered onsite, in your company’s meeting room.

Intended Audience

This course is designed for experienced Access users who need to manage and customize complex databases.

Prerequisites

Access 2013 Level 2

Agenda

Lesson 1: Macros

  • Creating and running macros
  • Macro groups
  • Macro conditions

Lesson 2: Switchboard

  • Overview of switchboards
  • Creating and customizing switchboards

Lesson 3: Customizing Access

  • Configuring default settings
  • Building custom navigation

Lesson 4: Administrative Functions

  • Database management and maintenance tasks

Lesson 5: Database Security

  • Configuring security settings
  • Trust Center

Clients

We work with government and private sector clients throughout Ontario.

Aecon Logo

CBC Radio Canada Logo

Health Canada Logo

Sobeys Logo

World Vision Logo
Back to Top