Access Course: Strengthen Your Database Management

Skill	Pre-assess	Lesson	Post-assess	Learning mode

Access Intermediate Course Outline

Verified Learning

Skill	Pre-assess	Lesson	Post-assess
Create Relational Databases
Table Relationships and Relationship Types Manage table relationships and their types	Not Started	Not Started	Not Started
Create Relationships Between Tables Set Access table relationships and integrity	Not Started	Not Started	Not Started
Enforce Referential Integrity Maintain referential integrity in Access tables	Not Started	Not Started	Not Started
Print and Delete Relationships Print relationship diagrams or remove links	Not Started	Not Started	Not Started

Skill	Pre-assess	Lesson	Post-assess	Learning mode
Work with Queries			Account Required
Create a Query How to create a query in Access step by step
Hide, Remove, and Sort Fields Hide remove and sort fields in Access
Use AND and OR Operators in a Query Combine criteria with AND and OR in Access
Create a Multiple Table Query Build a multiple table query in Access
Create a Calculated Field Create calculated fields in Access with formulas
Work with Expressions and the Expression Builder Expression Builder in Access for quick formulas
Format Fields within Queries Format query fields for clear data in Access
Use an IIF Function Access IIF function for conditional results
Summarize Groups of Records Summarize data in Access with group totals
Display Top or Bottom Values Show top or bottom results with query limits
Parameter Queries Create parameter queries in Access with prompts
Find Duplicate Records Access query to identify duplicate values
Find Unmatched Records Use the Unmatched Query Wizard to spot gaps
Crosstab Queries Access crosstab query to pivot and summarize
Delete Queries Remove records safely with an Access delete query
Append Queries Add records with an Access append query
Make-Table Queries Create a new table with a make table query
Update Queries Bulk edit records with an Access update query

Skill	Pre-assess	Lesson	Post-assess	Learning mode
Work with Forms			Account Required
Create a Form with the Form Wizard Build forms fast with Access Form Wizard
Create and Use a Form Access form design fields controls data entry
Modify a Form in Layout View Refine form layout in Access with live tweaks
Form Design View Basics Access Design View for form layout and controls
Change the Tab Order Access form tab order navigation
Work with Control Properties Adjust control properties for Access forms
Work with Form Properties Edit form properties in Access
Change a Controls Data Source Set the Control Source property in Access
Create a Calculated Control Compute values with calculated control in Access
Change a Controls Default Value Set default values for controls in Access
Create a Subform How to create a subform in Access
Work with and Modify Subforms Edit Access subforms layout and links
Create and Modify a Navigation Form Build an Access navigation form with tabs

Skill	Pre-assess	Lesson	Post-assess	Learning mode
Work with Reports			Account Required
Create a Report Build and format reports in Access
Use the Report Wizard Build reports fast with the Access Report Wizard
Use the Label Wizard Create labels fast with Access Label Wizard
Work in Layout View Edit forms live in Access Layout View
Format Fonts Change text size color and style in Access
Copy Formatting Copy styles across Access fields fast
Change Text Alignment Align text left, center, or right in Access
Insert a Logo and Background Image Add a logo and background image to reports
Adjust Page Margin and Orientation Adjust page margins and orientation in Access
Add Page Numbers and Dates Insert page numbers and dates in Access
Group and Sort Group and sort records in Access reports
Summarize Data using Totals Add Totals to quickly summarize Access data
Understand Report Sections Access report sections from header to footer

Skill	Pre-assess	Lesson	Post-assess	Learning mode
Advanced Topics			Account Required
Use Conditional Formatting Conditional formatting in Access highlights data
Work with Number Formatting Access number formats currency percent
Use Themes Apply and customize themes in Access
Import Information How to import data from Access to Excel
Export Information Send Access data to Excel, CSV, or PDF
Link External Information Link external data sources to Access tables
Mail Merge Records to Word Merge Access records into Word documents
Use Hyperlink Fields Add and open hyperlinks in Access tables
Database Object Dependencies View object dependencies in Access
Compact and Repair a Database Reduce size and fix errors in Access databases
Convert an Access Database Upgrade Access database format safely
Back Up and Restore a Database Safely back up and restore your Access database
Password Protect a Database Protect Access database with a password
Split a Database Separate front end and backend for faster Access

Student Downloads

Concise, easy-to-use guide for quick learning and reference.

Get a Completion Certificate

Share your certificate with prospective employers and your professional network.

Your Name

For verified skills in: Access Intermediate

Issued on December 04, 2025