Microsoft Access Training

We offer 3 levels of Microsoft Access training.

Access Level 1 Database Design
Details | Request a Quote

Access Level 2 Advanced Database Design
Details | Request a Quote

Access Level 3 Advanced Topics
Details | Request a Quote

Access Level 1 Database Design

Training available for Access 2013 / 2016 / 2019 or Excel for Office 365. Delivery via Online LIVE.

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.

Back to Top


Access Level 2 Advanced Database Design

Training available for Access 2013 / 2016 / 2019 or Excel for Office 365. Delivery via Online LIVE. Prerequisite: Access Level 1.

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.

Back to Top


Access Level 3 Advanced Topics

Training available for Access 2013 / 2016 / 2019 or Excel for Office 365. Delivery via Online LIVE. Prerequisite: Access Level 2.

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.

Back to Top


Microsoft Access is a registered trademark of Microsoft Corporation. onsite‑training.com provides Access training but is not affiliated with Microsoft.