![]()
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
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 |
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 |
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 |
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 |
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 |