Log In
Access 2021 Intermediate

Access 2021 Intermediate

Features:

  • Interactive bite-sized lessons

  • Get Certified

  • Accurate skill assessments

  • Customizable, LMS-ready content

Prices
Users love us
4.9 stars out of 5 on G2

4.9 out of 5 on G2

Access 2021 Intermediate

6 hour course

Enhance your Access skills by mastering relational databases, advanced queries, and form design in this intermediate course.

Learn to:

  • Create relational databases
  • Build queries
  • Design & use forms
  • Create professional reports

Features:

  • Learn by doing simulations
  • Skill assessments
  • Covers Certiport certification
Certiport certification
Skill Pre-assess Lesson Post-assess Learning mode
Access 2021 Intermediate Try this course with a
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
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