- Courses
- Access 2021 Basic
5 hour course
Access 2021 Basic
4.9 out of 5 on G2
Try this course with a Free Trial
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 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 | ||||