Access 2021 Intermediate
Try this course with a Free Trial
|
||||
What you'll learn:
- Build multi-table relational databases.
- Create queries to find, update, add & delete records.
- Add forms and reports to your database.
- Summarize database information with queries & reports.
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 |
|---|---|---|---|---|
| Create Relational Databases |
Verified Learning
|
|||
| Table Relationships and Relationship Types Click to start | Not Started | Not Started | Not Started | |
| Create Relationships Between Tables | Not Started | Not Started | Not Started | |
| Enforce Referential Integrity | Not Started | Not Started | Not Started | |
| Print and Delete Relationships | Not Started | Not Started | Not Started | |
| Skill | Pre-assess | Lesson | Post-assess | Learning mode |
|---|---|---|---|---|
| Work with Queries |
Verified Learning
|
|||
| Create a Query | Account Required | |||
| Hide, Remove, and Sort Fields | ||||
| Use AND and OR Operators in a Query | ||||
| Create a Multiple Table Query | ||||
| Create a Calculated Field | ||||
| Work with Expressions and the Expression Builder | ||||
| Format Fields within Queries | ||||
| Use an IIF Function | ||||
| Summarize Groups of Records | ||||
| Display Top or Bottom Values | ||||
| Parameter Queries | ||||
| Find Duplicate Records | ||||
| Find Unmatched Records | ||||
| Crosstab Queries | ||||
| Delete Queries | ||||
| Append Queries | ||||
| Make-Table Queries | ||||
| Update Queries | ||||
| Skill | Pre-assess | Lesson | Post-assess | Learning mode |
|---|---|---|---|---|
| Work with Forms |
Verified Learning
|
|||
| Create a Form with the Form Wizard | ||||
| Create and Use a Form | ||||
| Modify a Form in Layout View | ||||
| Form Design View Basics | ||||
| Change the Tab Order | ||||
| Work with Control Properties | ||||
| Work with Form Properties | ||||
| Change a Controls Data Source | ||||
| Create a Calculated Control | ||||
| Change a Controls Default Value | ||||
| Create a Subform | ||||
| Work with and Modify Subforms | ||||
| Create and Modify a Navigation Form | ||||
| Skill | Pre-assess | Lesson | Post-assess | Learning mode |
|---|---|---|---|---|
| Work with Reports |
Verified Learning
|
|||
| Create a Report | ||||
| Use the Report Wizard | ||||
| Use the Label Wizard | ||||
| Work in Layout View | ||||
| Format Fonts | ||||
| Copy Formatting | ||||
| Change Text Alignment | ||||
| Insert a Logo and Background Image | ||||
| Adjust Page Margin and Orientation | ||||
| Add Page Numbers and Dates | ||||
| Group and Sort | ||||
| Summarize Data using Totals | ||||
| Understand Report Sections | ||||
| Skill | Pre-assess | Lesson | Post-assess | Learning mode |
|---|---|---|---|---|
| Advanced Topics |
Verified Learning
|
|||
| Use Conditional Formatting | ||||
| Work with Number Formatting | ||||
| Use Themes | ||||
| Import Information | ||||
| Export Information | ||||
| Link External Information | ||||
| Mail Merge Records to Word | ||||
| Use Hyperlink Fields | ||||
| Database Object Dependencies | ||||
| Compact and Repair a Database | ||||
| Convert an Access Database | ||||
| Back Up and Restore a Database | ||||
| Password Protect a Database | ||||
| Split a Database | ||||
Quick Answer: