Access 2019 Basic
Try this course with a Free Trial
|
||||
What you'll learn:
- Learn database basics: tables, queries, forms, reports.
- Find, filter, sort database information.
- Create databases, tables, and different field types.
- Understand fundamental database principles.
What’s Included:
-
Customizable, LMS-compatible content
-
Skill assessments
-
Bite-sized, interactive lessons
-
LinkedIn-ready skills certificate
| 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 | ||||
Quick Answer: