Software training across Canada

Microsoft Access training adapted to the actual level

45-question technical assessment drawn from a 72-question bank to place a learner in Microsoft Access and recommend the most useful training modules.

Microsoft Access diagnostic: practical skills, workflows and training priorities.

Start the free assessment Request delivery terms

Approach

Build the path around observed needs

The free assessment helps separate concepts already mastered from those that deserve training. The final path can then be adjusted to the organization’s tasks, context and objectives.

The diagnostic is not an official certification. It is used to guide training decisions.

Intended audience

database users and operational teams

Employees and professionals.
Managers and HR teams.
Training coordinators.
Groups to be organized by skill level.

Visible content

Microsoft Access training modules

The modules below come from the catalogue used by the recommendation engine. Their order and depth are adapted after the assessment or engagement analysis.

Module M01

Tables, fields and relational design

Practical 3-hour module covering Table, Field, Primary key, and Data type.

store records about a specific subject
define a piece of information and its data type in a table
uniquely identify each record in a table
control the kind of values a field can store

3 h

Module M02

Relationships and referential integrity

Practical 3-hour module covering One-to-many relationship, Foreign key, Referential integrity, and Relationships window.

link one parent row to many child rows
store the associated parent key in the child table
prevent orphaned or inconsistent relationships between tables
view and manage relationships among tables

3 h

Module M03

Select queries and criteria

Practical 3-hour module covering Select query, Criterion, Join, and Calculated field.

retrieve a subset of data without changing source tables
limit returned records according to a condition
combine rows from multiple tables based on related fields
produce a derived value in a query result

3 h

Module M04

Advanced and action queries

Practical 3-hour module covering Parameter query, Totals query, Crosstab query, and Action query.

ask the user for a value before applying criteria
group and aggregate records with sum, count, or average
summarize data in a row-and-column matrix
append, update, delete, or create data in bulk

3 h

Module M05

Forms and controlled data entry

Practical 3-hour module covering Form, Control, Subform, and Validation.

provide a friendly interface to view or enter data
display or edit a value such as text, list, or button
display child records related to the current parent
reject values that do not meet a data entry rule

3 h

Module M06

Reports and data presentation

Practical 3-hour module covering Report, Grouping, Sorting, and Group total.

present data for reading, printing, or distribution
organize report records by a common value
order records in the report
calculate a sum or other aggregate for each group

3 h

Module M07

Importing, linking and external data

Practical 3-hour module covering Import, Linked table, Excel, and ODBC.

copy external data into Access tables
use an external source without physically copying all its data into the file
exchange or prepare tabular data with a workbook
connect Access to compatible data sources such as certain SQL servers

3 h

Module M08

Macros and automation

Practical 3-hour module covering Access macro, Event, VBA, and Error handling.

automate a sequence of actions without necessarily writing VBA
trigger a macro or procedure when a user action occurs
program more customized and complex logic in Access
provide a controlled response when an automated operation fails

3 h

Module M09

Performance, maintenance and deployment

Practical 3-hour module covering Index, Split database, Compact and Repair, and Object dependencies.

speed selected searches and joins on well-chosen fields
separate data tables from the interface for more robust multi-user use
reduce file bloat and fix some internal issues
analyze which forms, queries, or reports depend on other objects

3 h

Canada

Availability for provinces and territories

JFL Media can receive requests from anywhere in Canada. Delivery terms, time zone, availability, location and pricing are confirmed for each engagement.

View service areas →

Before training

Complete the assessment or describe the need precisely.
Choose modules and confirm duration.
Confirm delivery terms, availability and price.

Next step

Start by establishing the Microsoft Access level.

The assessment is free and produces a detailed report that can be used to prepare a focused path.

Start the assessment