Courses
Access 2016 Intermediate

6 hour course

Access 2016 Intermediate

4.9 out of 5 on G2

Try this course with a Free Trial

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 2016 Intermediate Outline

Skill	Pre-assess	Lesson	Post-assess	Learning mode
Create Relational Databases			Verified Learning
Table Relationships and Relationship Types Understand Table Relationships and Relationship Types in Access	Not Started	Not Started	Not Started
Create Relationships Between Tables How to Create Relationships Between Tables in Access	Not Started	Not Started	Not Started
Enforce Referential Integrity How to Enforce Referential Integrity in Access	Not Started	Not Started	Not Started
Print and Delete Relationships How to Print and Delete Relationships in Access	Not Started	Not Started	Not Started

Skill	Pre-assess	Lesson	Post-assess	Learning mode
Work with Queries			Verified Learning
Create a Query How to Create a Query in Access	Account Required
Hide, Remove, and Sort Fields How to Hide, Remove, and Sort Fields in Access
Use AND and OR Operators in a Query How to Use AND and OR Operators in a Query in Access
Create a Multiple Table Query How to Create a Multiple Table Query in Access
Create a Calculated Field How to Create a Calculated Field in Access
Work with Expressions and the Expression Builder How to Work with Expressions and the Expression Builder in Access
Format Fields within Queries How to Format Fields within Queries in Access
Use an IIF Function How to Use an IIF Function in Access
Summarize Groups of Records How to Summarize Groups of Records in Access
Display Top or Bottom Values How to Display Top or Bottom Values in Access
Parameter Queries How to Create Parameter Queries in Access
Find Duplicate Records How to Find Duplicate Records in Access
Find Unmatched Records How to Find Unmatched Records in Access
Crosstab Queries How to Create Crosstab Queries in Access
Delete Queries How to Create Delete Queries in Access
Append Queries How to Create Append Queries in Access
Make-Table Queries How to Create Make Table Queries in Access
Update Queries How to Create Update Queries in Access

Skill	Pre-assess	Lesson	Post-assess	Learning mode
Work with Forms			Verified Learning
Create a Form with the Form Wizard Create a Form Using the Form Wizard in Access
Create and Use a Form How to Create and Use a Form in Access
Modify a Form in Layout View How to Modify a Form in Layout View in Access
Form Design View Basics How to Use Form Design View in Access
Change the Tab Order How to Change the Tab Order in Access
Work with Control Properties How to Work with Control Properties in Access
Work with Form Properties How to Work with Form Properties in Access
Change a Controls Data Source How to Change a Controls Data Source in Access
Create a Calculated Control How to Create a Calculated Control in Access
Change a Controls Default Value How to Change a Controls Default Value in Access
Create a Subform How to Create a Subform in Access
Work with and Modify Subforms How to Work with and Modify Subforms in Access
Create and Modify a Navigation Form How to Create and Modify a Navigation Form in Access

Skill	Pre-assess	Lesson	Post-assess	Learning mode
Work with Reports			Verified Learning
Create a Report How to Create a Report in Access
Use the Report Wizard How to Use the Report Wizard in Access
Use the Label Wizard How to Use the Label Wizard in Access
Work in Layout View How to Work in Layout View in Access
Format Fonts How to Format Fonts in Access
Copy Formatting How to Copy Formatting in Access
Change Text Alignment How to Change Text Alignment in Access
Insert a Logo and Background Image How to Insert a Logo and Background Image in Access
Adjust Page Margin and Orientation How to the Adjust Page Margin and Orientation in Access
Add Page Numbers and Dates How to Add Page Numbers and Dates in Access
Group and Sort How to Group and Sort in Access
Summarize Data using Totals How to Summarize Data using Totals in Access
Understand Report Sections How to Understand Report Sections in Access

Skill	Pre-assess	Lesson	Post-assess	Learning mode
Advanced Topics			Verified Learning
Use Conditional Formatting How to Use Conditional Formatting in Access
Work with Number Formatting How to Work with Number Formatting in Access
Use Themes How to Use Themes in Access
Import Information How to Import Information in Access
Export Information How to Export Information from Access
Link External Information How to Link External Information in Access
Mail Merge Records to Word How to Create a Word Merge with Access Data
Use Hyperlink Fields How to Use Hyperlink Fields in Access
Database Object Dependencies How to Database Object Dependencies in Access
Compact and Repair a Database How to Compact and Repair a Database in Access
Convert an Access Database How to Convert an Access Database
Back Up and Restore a Database How to Back Up and Restore a Database in Access
Password Protect a Database How to Password Protect a Database in Access
Split a Database How to Split a Database in Access