Free online assessment

Assess your Microsoft Access skills for free

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

This assessment measures knowledge and produces a practical diagnostic. Modules are recommended after the test; they are not an offer of paid courses.

Start for free How does the test work?

What is assessed

Questions about practical workplace skills

The test covers different areas of the software, including beginner, intermediate and advanced questions. The score and skill-area breakdown help reveal strengths and topics to revisit.

This is not an official certification and should not be the sole factor in an employment decision.

Who can use it

database users and operational teams

Employees and applicants.
HR professionals.
Employers, managers and team leads.

Assessment learning framework

Modules that may appear in your recommended plan

The topics below form the recommendation framework associated with this assessment. The system selects priorities using individual answers and proposes a plan to use independently with a provider of your choice. We do not deliver these courses through this website.

Topic 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

Topic 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

Topic 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

Topic 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

Topic 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

Topic 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

Topic 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

Topic 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

Topic 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

Assessment output

Actionable insight, not a sales pitch

The report provides an overall score, category breakdown and recommended modules. Use it to inform development discussions, document progress or complement candidate assessment.

View business use cases →

Privacy and recipients

The participant provides their email and that of the manager or authorized report recipient. The tool emails the report to those recipients according to its current process. Do not enter a third party without permission.

Review privacy information

Free assessment

Ready to assess your Microsoft Access skills?

45 questions and a suggested development plan. No course enrollment.

Take the free test