Chat with us, powered by LiveChat

Microsoft Access Training

Learn by doing, not watching, with interactive Access simulations.

freetrial

Proven Learning Method

  • Measure existing skills with simulation-based assessments.
  • Improve skills gaps with bite-sized interactive tutorials.
  • Verify learning with post assessments.
  • Endorse skills with certificates.

Access Training Features

  • Interactive-training Interactive; learn by doing, instead of passively watching long, boring videos.
  • Customizable-content Customizable, select only the skills you want and the learning method you need.
  • Scorm-compatible SCORM-compliant; and will work great in your LMS.

Courses are available for Access 2016 and 2013; Spanish editions also available.

Average Improvement Results

Collapse All Assess Learn Verify Improvement
Access Training

Microsoft Access Basic Training

61%
97%
36%

The Fundamentals demo

67%
98%
30%

Understand the Screen

Click to try Not Started Not Started Not Started

Open and Save a Database

Not Started Not Started Not Started

Work with Database Objects

Not Started Not Started Not Started

Tour of Tables

Not Started Not Started Not Started

Tour of Queries

Not Started Not Started Not Started

Tour of Forms

Not Started Not Started Not Started

Tour of Reports

Not Started Not Started Not Started

Help

Not Started Not Started Not Started

Close and Exit Access

Not Started Not Started Not Started

Create and Work with a Database lock Subscribe to unlock

59%
98%
39%

Plan a Database

Create a Database

Add, Edit, and Delete Records

Select Data

Cut, Copy, and Paste Data

Use Undo and Redo

Check Spelling

Use the Zoom Box

Find, Filter, and Format Data lock Subscribe to unlock

57%
98%
40%

Find and Replace Data

Sort Records

Use Common Filters

Filter by Selection

Filter by Form

Create an Advanced Filter

Adjust Rows and Columns

Change Gridlines and Cell Effects

Freeze a Column

Hide a Column

Tables lock Subscribe to unlock

60%
98%
38%

Create a Table

Understand Field Types and Properties

Index a Field

Add a Primary Key and Auto-Increment Fields

Insert, Reorder, and Delete Fields

Add Field Descriptions and Captions

Change the Field Size

Format Number, Currency, and Date/Time Fields

Format Text Fields

Set a Default Value

Require Data Entry

Validate Data

Create an Input Mask

Create a Lookup Field

Create a Value List

Modify a Lookup List

Add Total Rows

Access Training

Microsoft Access Intermediate Training

48%
98%
49%

Create Relational Databases lock Subscribe to unlock

52%
98%
45%

Table Relationships and Relationship Types

Create Relationships Between Tables

Enforce Referential Integrity

Print and Delete Relationships

Work with Queries lock Subscribe to unlock

51%
99%
48%

Create a Query

Hide, Remove, and Sort Fields

Use AND and OR Operators in a Query

Create a Multiple Table Query

Create a Calculated Field

Work with Expressions and the Expression Builder

Format Fields within Queries

Use an IIF Function

Summarize Groups of Records

Display Top or Bottom Values

Parameter Queries

Find Duplicate Records

Find Unmatched Records

Crosstab Queries

Delete Queries

Append Queries

Make-Table Queries

Update Queries

Work with Forms lock Subscribe to unlock

40%
99%
59%

Create a Form with the Form Wizard

Create and Use a Form

Modify a Form in Layout View

Form Design View Basics

Change the Tab Order

Work with Control Properties

Work with Form Properties

Change a Controls Data Source

Create a Calculated Control

Change a Controls Default Value

Create a Subform

Work with and Modify Subforms

Create and Modify a Navigation Form

Work with Reports lock Subscribe to unlock

54%
99%
45%

Create a Report

Use the Report Wizard

Use the Label Wizard

Work in Layout View

Format Fonts

Copy Formatting

Change Text Alignment

Insert a Logo and Background Image

Adjust Page Margin and Orientation

Add Page Numbers and Dates

Group and Sort

Summarize Data using Totals

Understand Report Sections

Advanced Topics lock Subscribe to unlock

45%
99%
54%

Use Conditional Formatting

Work with Number Formatting

Use Themes

Import Information

Export Information

Link External Information

Mail Merge Records to Word

Use Hyperlink Fields

Database Object Dependencies

Compact and Repair a Database

Convert an Access Database

Back Up and Restore a Database

Password Protect a Database

Split a Database