Access Training
Features:
-
Interactive bite-sized lessons
-
Get Certified
-
Accurate skill assessments
-
Customizable, LMS-ready content
Access Training
Learn to:
- Plan & create databases
- Add & enter records
- Find, filter, &sort data
- Create & work with tables
Features:
| Skill | Pre-assess | Lesson | Post-assess | Learning mode |
|---|
Access Training
Account Required:
Try this course with a
Free Trial
|
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 | |