Courses
Access 2021 Basic

5 hour course

Access 2021 Basic

4.9 out of 5 on G2

Try this course with a Free Trial

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 2021 Basic Outline

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

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

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

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