- Courses
- Access 2021 Basic

Access 2021 Basic
Features:
-
Interactive bite-sized lessons
-
Get Certified
-
Accurate skill assessments
-
Customizable, LMS-ready content
Access 2021 Basic
5 hour course
Learn to:
- Plan & create databases
- Add & enter records
- Find, filter, &sort data
- Create & work with tables
Skill | Pre-assess | Lesson | Post-assess | Learning mode |
---|
Access 2021 Basic
Try this course with a Free Trial
|
Skill | Pre-assess | Lesson | Post-assess | Learning mode |
---|---|---|---|---|
Access Fundamentals |
Verified Learning
|
|||
Understand the Screen Click to start | 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 |
Skill | Pre-assess | Lesson | Post-assess | Learning mode |
---|---|---|---|---|
Work with Databases |
Verified Learning
|
|||
Plan a Database | Account Required | |||
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 | ||||
Preview and Print |
Skill | Pre-assess | Lesson | Post-assess | Learning mode |
---|---|---|---|---|
Work with Data |
Verified Learning
|
|||
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 |
Skill | Pre-assess | Lesson | Post-assess | Learning mode |
---|---|---|---|---|
Tables |
Verified Learning
|
|||
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 |