Courses
Access Training

Access Training

4.9 out of 5 on G2

Try this course with a Free Trial

Access Training

New to Microsoft Access? This course helps you master database creation, record management, and table design basics.

Learn to:

Plan & create databases
Add & enter records
Find, filter, &sort data
Create & work with tables

Features:

Learn by doing simulations
Skill assessments
Covers Certiport certification

Certiport certification

Skill	Pre-assess	Lesson	Post-assess	Learning mode

Access Training

Access Training Outline

Verified Learning

Skill	Pre-assess	Lesson	Post-assess	Learning mode
Access Fundamentals
Understand the Screen Understand the Access Screen	Account Req	Not Started	Account Req
Open and Save a Database How to Open a Database in Access	Account Req	Not Started	Account Req
Work with Database Objects How to Work with Database Objects in Access	Account Req	Not Started	Account Req
Tour of Tables Tour of Tables in Access	Account Req	Not Started	Account Req
Tour of Queries Tour of Queries in Access	Account Req	Not Started	Account Req
Tour of Forms How to Add a Record in Access	Account Req	Not Started	Account Req
Tour of Reports Tour of Reports in Access	Account Req	Not Started	Account Req
Help How to Get Help in Access	Account Req	Not Started	Account Req
Close and Exit Access How to Close and Exit Access	Account Req	Not Started	Account Req

Skill	Pre-assess	Lesson	Post-assess	Learning mode
Work with Databases
Plan a Database How to Plan a Database in Access	Account Req	Not Started	Account Req
Create a Database How to Create a Database in Access	Account Req	Not Started	Account Req
Add, Edit, and Delete Records How to Add, Edit, and Delete Records in Access	Account Req	Not Started	Account Req
Select Data How to Select Data in Access	Account Req	Not Started	Account Req
Cut, Copy, and Paste Data How to Cut, Copy, and Paste Data in Access	Account Req	Not Started	Account Req
Use Undo and Redo How to Use Undo and Redo in Access	Account Req	Not Started	Account Req
Check Spelling How to Check your Spelling in Access	Account Req	Not Started	Account Req
Use the Zoom Box How to Use the Zoom Box in Access	Account Req	Not Started	Account Req
Preview and Print How to Preview and Print in Access	Account Req	Not Started	Account Req

Skill	Pre-assess	Lesson	Post-assess	Learning mode
Work with Data
Find and Replace Data How to Find and Replace Data in Access	Account Req	Not Started	Account Req
Sort Records How to Sort Records in Access	Account Req	Not Started	Account Req
Use Common Filters How to Use Common Filters in Access	Account Req	Not Started	Account Req
Filter by Selection How to Filter by Selection in Access	Account Req	Not Started	Account Req
Filter by Form How to Filter by Form in Access	Account Req	Not Started	Account Req
Create an Advanced Filter How to Create an Advanced Filter in Access	Account Req	Not Started	Account Req
Adjust Rows and Columns How to Adjust Rows and Columns in Access	Account Req	Not Started	Account Req
Change Gridlines and Cell Effects How to Change Gridlines and Cell Effects in Access	Account Req	Not Started	Account Req
Freeze a Column How to Freeze a Column in Access	Account Req	Not Started	Account Req
Hide a Column How to Hide a Column in Access	Account Req	Not Started	Account Req

Skill	Pre-assess	Lesson	Post-assess	Learning mode
Tables
Create a Table How to Create a Table in Access	Account Req	Not Started	Account Req
Understand Field Types and Properties How to Understand Field Types and Properties in Access	Account Req	Not Started	Account Req
Index a Field How to Index a Field in Access	Account Req	Not Started	Account Req
Add a Primary Key and Auto-Increment Fields How to Add a Primary Key and Auto-Increment Fields in Access	Account Req	Not Started	Account Req
Insert, Reorder, and Delete Fields How to Insert, Reorder, and Delete Fields in Access	Account Req	Not Started	Account Req
Add Field Descriptions and Captions How to Add Field Descriptions and Captions in Access	Account Req	Not Started	Account Req
Change the Field Size How to Change the Field Size in Access	Account Req	Not Started	Account Req
Format Number, Currency, and Date/Time Fields How to Format Number, Currency, and Date/Time Fields in Access	Account Req	Not Started	Account Req
Format Text Fields How to Format Text Fields in Access	Account Req	Not Started	Account Req
Set a Default Value How to Set a Default Value in Access	Account Req	Not Started	Account Req
Require Data Entry How to Require Data Entry in Access	Account Req	Not Started	Account Req
Validate Data How to Validate Data in Access	Account Req	Not Started	Account Req
Create an Input Mask How to Create an Input Mask in Access	Account Req	Not Started	Account Req
Create a Lookup Field How to Create a Lookup Field in Access	Account Req	Not Started	Account Req
Create a Value List How to Create a Value List in Access	Account Req	Not Started	Account Req
Modify a Lookup List How to Modify a Lookup List in Access	Account Req	Not Started	Account Req
Add Total Rows How to Add Total Rows in Access	Account Req	Not Started	Account Req

Skill	Pre-assess	Lesson	Post-assess	Learning mode
Create Relational Databases
Table Relationships and Relationship Types Understand Table Relationships and Relationship Types in Access	Account Req	Not Started	Account Req
Create Relationships Between Tables How to Create Relationships Between Tables in Access	Account Req	Not Started	Account Req
Enforce Referential Integrity How to Enforce Referential Integrity in Access	Account Req	Not Started	Account Req
Print and Delete Relationships How to Print and Delete Relationships in Access	Account Req	Not Started	Account Req

Skill	Pre-assess	Lesson	Post-assess	Learning mode
Work with Queries
Create a Query How to Create a Query in Access	Account Req	Not Started	Account Req
Hide, Remove, and Sort Fields How to Hide, Remove, and Sort Fields in Access	Account Req	Not Started	Account Req
Use AND and OR Operators in a Query How to Use AND and OR Operators in a Query in Access	Account Req	Not Started	Account Req
Create a Multiple Table Query How to Create a Multiple Table Query in Access	Account Req	Not Started	Account Req
Create a Calculated Field How to Create a Calculated Field in Access	Account Req	Not Started	Account Req
Work with Expressions and the Expression Builder How to Work with Expressions and the Expression Builder in Access	Account Req	Not Started	Account Req
Format Fields within Queries How to Format Fields within Queries in Access	Account Req	Not Started	Account Req
Use an IIF Function How to Use an IIF Function in Access	Account Req	Not Started	Account Req
Summarize Groups of Records How to Summarize Groups of Records in Access	Account Req	Not Started	Account Req
Display Top or Bottom Values How to Display Top or Bottom Values in Access	Account Req	Not Started	Account Req
Parameter Queries How to Create Parameter Queries in Access	Account Req	Not Started	Account Req
Find Duplicate Records How to Find Duplicate Records in Access	Account Req	Not Started	Account Req
Find Unmatched Records How to Find Unmatched Records in Access	Account Req	Not Started	Account Req
Crosstab Queries How to Create Crosstab Queries in Access	Account Req	Not Started	Account Req
Delete Queries How to Create Delete Queries in Access	Account Req	Not Started	Account Req
Append Queries How to Create Append Queries in Access	Account Req	Not Started	Account Req
Make-Table Queries How to Create Make Table Queries in Access	Account Req	Not Started	Account Req
Update Queries How to Create Update Queries in Access	Account Req	Not Started	Account Req

Skill	Pre-assess	Lesson	Post-assess	Learning mode
Work with Forms
Create a Form with the Form Wizard Create a Form Using the Form Wizard in Access	Account Req	Not Started	Account Req
Create and Use a Form How to Create and Use a Form in Access	Account Req	Not Started	Account Req
Modify a Form in Layout View How to Modify a Form in Layout View in Access	Account Req	Not Started	Account Req
Form Design View Basics How to Use Form Design View in Access	Account Req	Not Started	Account Req
Change the Tab Order How to Change the Tab Order in Access	Account Req	Not Started	Account Req
Work with Control Properties How to Work with Control Properties in Access	Account Req	Not Started	Account Req
Work with Form Properties How to Work with Form Properties in Access	Account Req	Not Started	Account Req
Change a Controls Data Source How to Change a Controls Data Source in Access	Account Req	Not Started	Account Req
Create a Calculated Control How to Create a Calculated Control in Access	Account Req	Not Started	Account Req
Change a Controls Default Value How to Change a Controls Default Value in Access	Account Req	Not Started	Account Req
Create a Subform How to Create a Subform in Access	Account Req	Not Started	Account Req
Work with and Modify Subforms How to Work with and Modify Subforms in Access	Account Req	Not Started	Account Req
Create and Modify a Navigation Form How to Create and Modify a Navigation Form in Access	Account Req	Not Started	Account Req

Skill	Pre-assess	Lesson	Post-assess	Learning mode
Work with Reports
Create a Report How to Create a Report in Access	Account Req	Not Started	Account Req
Use the Report Wizard How to Use the Report Wizard in Access	Account Req	Not Started	Account Req
Use the Label Wizard How to Use the Label Wizard in Access	Account Req	Not Started	Account Req
Work in Layout View How to Work in Layout View in Access	Account Req	Not Started	Account Req
Format Fonts How to Format Fonts in Access	Account Req	Not Started	Account Req
Copy Formatting How to Copy Formatting in Access	Account Req	Not Started	Account Req
Change Text Alignment How to Change Text Alignment in Access	Account Req	Not Started	Account Req
Insert a Logo and Background Image How to Insert a Logo and Background Image in Access	Account Req	Not Started	Account Req
Adjust Page Margin and Orientation How to the Adjust Page Margin and Orientation in Access	Account Req	Not Started	Account Req
Add Page Numbers and Dates How to Add Page Numbers and Dates in Access	Account Req	Not Started	Account Req
Group and Sort How to Group and Sort in Access	Account Req	Not Started	Account Req
Summarize Data using Totals How to Summarize Data using Totals in Access	Account Req	Not Started	Account Req
Understand Report Sections How to Understand Report Sections in Access	Account Req	Not Started	Account Req

Skill	Pre-assess	Lesson	Post-assess	Learning mode
Advanced Topics
Use Conditional Formatting How to Use Conditional Formatting in Access	Account Req	Not Started	Account Req
Work with Number Formatting How to Work with Number Formatting in Access	Account Req	Not Started	Account Req
Use Themes How to Use Themes in Access	Account Req	Not Started	Account Req
Import Information How to Import Information in Access	Account Req	Not Started	Account Req
Export Information How to Export Information from Access	Account Req	Not Started	Account Req
Link External Information How to Link External Information in Access	Account Req	Not Started	Account Req
Mail Merge Records to Word How to Create a Word Merge with Access Data	Account Req	Not Started	Account Req
Use Hyperlink Fields How to Use Hyperlink Fields in Access	Account Req	Not Started	Account Req
Database Object Dependencies How to Database Object Dependencies in Access	Account Req	Not Started	Account Req
Compact and Repair a Database How to Compact and Repair a Database in Access	Account Req	Not Started	Account Req
Convert an Access Database How to Convert an Access Database	Account Req	Not Started	Account Req
Back Up and Restore a Database How to Back Up and Restore a Database in Access	Account Req	Not Started	Account Req
Password Protect a Database How to Password Protect a Database in Access	Account Req	Not Started	Account Req
Split a Database How to Split a Database in Access	Account Req	Not Started	Account Req