Access Intermediate
Access Intermediate
|
||||
Try Limited, Free Training:
- 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.
Upgrade to Experience:
-
LinkedIn-ready certificates that verify your skills
-
Skill assessments
-
Unlocked courses & interactive content
-
Customizable content; create your own courses
| Skill | Pre-assess | Lesson | Post-assess | Learning mode |
|---|---|---|---|---|
| Create Relational Databases | Limited Free Learning | |||
| Table Relationships and Relationship Types | Click to start | Not Started | Not included | |
| Create Relationships Between Tables | Not included | Not Started | Not included | |
| Enforce Referential Integrity | Not included | Not Started | Not included | |
| Print and Delete Relationships | Not included | Not Started | Not included | |
| Skill | Pre-assess | Lesson | Post-assess | Learning mode |
|---|---|---|---|---|
| Work with Queries | Limited Free Learning | |||
| Create a Query | Not included | Not Started | Not included | |
| Hide, Remove, and Sort Fields | Not included | Not Started | Not included | |
| Use AND and OR Operators in a Query | Not included | Not Started | Not included | |
| Create a Multiple Table Query | Not included | Not Started | Not included | |
| Create a Calculated Field | Not included | Not Started | Not included | |
| Work with Expressions and the Expression Builder | Not included | Not Started | Not included | |
| Format Fields within Queries | Not included | Not Started | Not included | |
| Use an IIF Function | Not included | Not Started | Not included | |
| Summarize Groups of Records | Not included | Not Started | Not included | |
| Display Top or Bottom Values | Not included | Not Started | Not included | |
| Parameter Queries | Not included | Not Started | Not included | |
| Find Duplicate Records | Not included | Not Started | Not included | |
| Find Unmatched Records | Not included | Not Started | Not included | |
| Crosstab Queries | Not included | Not Started | Not included | |
| Delete Queries | Not included | Not Started | Not included | |
| Append Queries | Not included | Not Started | Not included | |
| Make-Table Queries | Not included | Not Started | Not included | |
| Update Queries | Not included | Not Started | Not included | |
| Skill | Pre-assess | Lesson | Post-assess | Learning mode |
|---|---|---|---|---|
| Work with Forms | Limited Free Learning | |||
| Create a Form with the Form Wizard | Not included | Not Started | Not included | |
| Create and Use a Form | Not included | Not Started | Not included | |
| Modify a Form in Layout View | Not included | Not Started | Not included | |
| Form Design View Basics | Not included | Not Started | Not included | |
| Change the Tab Order | Not included | Not Started | Not included | |
| Work with Control Properties | Not included | Not Started | Not included | |
| Work with Form Properties | Not included | Not Started | Not included | |
| Change a Controls Data Source | Not included | Not Started | Not included | |
| Create a Calculated Control | Not included | Not Started | Not included | |
| Change a Controls Default Value | Not included | Not Started | Not included | |
| Create a Subform | Not included | Not Started | Not included | |
| Work with and Modify Subforms | Not included | Not Started | Not included | |
| Create and Modify a Navigation Form | Not included | Not Started | Not included | |
| Skill | Pre-assess | Lesson | Post-assess | Learning mode |
|---|---|---|---|---|
| Work with Reports | Limited Free Learning | |||
| Create a Report | Not included | Not Started | Not included | |
| Use the Report Wizard | Not included | Not Started | Not included | |
| Use the Label Wizard | Not included | Not Started | Not included | |
| Work in Layout View | Not included | Not Started | Not included | |
| Format Fonts | Not included | Not Started | Not included | |
| Copy Formatting | Not included | Not Started | Not included | |
| Change Text Alignment | Not included | Not Started | Not included | |
| Insert a Logo and Background Image | Not included | Not Started | Not included | |
| Adjust Page Margin and Orientation | Not included | Not Started | Not included | |
| Add Page Numbers and Dates | Not included | Not Started | Not included | |
| Group and Sort | Not included | Not Started | Not included | |
| Summarize Data using Totals | Not included | Not Started | Not included | |
| Understand Report Sections | Not included | Not Started | Not included | |
| Skill | Pre-assess | Lesson | Post-assess | Learning mode |
|---|---|---|---|---|
| Advanced Topics | Limited Free Learning | |||
| Use Conditional Formatting | Not included | Not Started | Not included | |
| Work with Number Formatting | Not included | Not Started | Not included | |
| Use Themes | Not included | Not Started | Not included | |
| Import Information | Not included | Not Started | Not included | |
| Export Information | Not included | Not Started | Not included | |
| Link External Information | Not included | Not Started | Not included | |
| Mail Merge Records to Word | Not included | Not Started | Not included | |
| Use Hyperlink Fields | Not included | Not Started | Not included | |
| Database Object Dependencies | Not included | Not Started | Not included | |
| Compact and Repair a Database | Not included | Not Started | Not included | |
| Convert an Access Database | Not included | Not Started | Not included | |
| Back Up and Restore a Database | Not included | Not Started | Not included | |
| Password Protect a Database | Not included | Not Started | Not included | |
| Split a Database | Not included | Not Started | Not included | |