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