Access 2019 Basic
|
||||
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:
- Skill assessments
- Bite-sized, interactive lessons
- LinkedIn-ready skills certificate
- Customizable content
| 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 | |
| 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 | ||||
| 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 | ||||
| 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:
