Access 2019 Basic
Learn by doing—not watching—with interactive simulations.
8 users
Course Includes
-
Certificate of achievement -
Interactive tutorials -
Skills assessments -
Student manual, instructor guide, & practice files
What you'll learn
- Understand the basics of Access tables, queries, forms and reports.
- Learn how to find, filter, and sort database information.
- Plan and create databases, with tables and different types of fields.
- Gain an understanding of basic database principles.
Try sample lessons in the course outline shown below!
Proven Learning Method
| Skill | Assess | Learn | Verify | Improvement |
|---|---|---|---|---|
Access 2019 Basic |
Complete Course to Display Score | |||
Access Fundamentals
|
||||
Understand the Screen |
Click To Try 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 | |
Work with Databases
|
||||
Plan a Database |
 |
|||
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 |
||||
Work with Data
|
||||
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 |
||||
Tables
|
||||
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 |
||||
