Course:Access 2016 Intermediate | CustomGuide
Access 2016 Intermediate

Access 2016 Intermediate


100% Aligned to MOS Certification

Access 2016 Intermediate
Access 2016 Intermediate
Upgrade for Progress
Complete Course to Display Score
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
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
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
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
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