TRU4 Courses and Workshops

Revalidation for 2021 - Course Combo

Microsoft Access 2016 Essentials

Learners will gain a fundamental understanding of this database application’s environment and basic database principles. They will be able to demonstrate the correct use of key features and the ability to create and maintain tables, relationships, forms, reports, and queries.

Online Course / Classroom Training



Microsoft Access 2016 Essentials > Course Outline:

Workshop Objectives

Create and Modify Databases
Create a Blank Desktop Database
Create a Database from a Template
Create a Database by Using Import Objects or Data From Other Sources
Delete Database Objects
Manage Relationships and Keys
Set the Primary Key
View Relationships
Create and Modify Relationships
Set Foreign Keys
Enforce Referential Integrity
Navigate Through a Database
Display Objects in the Navigation Pane
Navigate Specific Records
Create and Modify a Navigation Form
Set a Form as the Startup Option
Change Views of Objects
Protect and Maintain Databases
Compact and Repair a Database
Back Up a Database
Recover Data from Backup
Split a Database
Encrypt a Database with a Password
Print and Export Data
Print Reports
Print Records
Save a Database as a Template 44
Export Objects to Alternative Formats
Module Two: Review Questions

Create Tables
Create a Table
Import Data into Tables
Create Linked Tables From External Sources
Import Tables from Other Databases
Create a Table from a Template with Application Parts
Manage Tables
Hide Fields in Tables
Add Total Rows
Rename Tables
Add Table Descriptions
Manage Records in Tables
Update Records
Add Records
Delete Records
Append Records from External Data
Find and Replace Data
Sort Records
Filter Records
Create and Modify Fields
Add Fields to Tables
Add Validation Rules to Fields
Change Field Captions
Change Field Sizes
Change Field Data Types
Configure Fields to Auto Increment
Set Default Values
Using Input Masks
Delete Fields
Review Questions: Module Three

Create a Query
Run a Query
Create a Crosstab Query
Add Parameter to a Query
Create an Action Query
Create a Multi-Table Query
Save a Query
Modify a Query
Rename a Query
Add Fields
Remove Fields
Hide Fields
Sort Data Within Queries
Format Fields Within Queries
Create Calculated Fields and Grouping Within Queries
Add Calculated Fields
Set Filtering Criteria
Use Comparison Operators
Use Arithmetic Operators
Use Logical Operators
Group and Summarize Data
Module Four Review Questions

Create a Form
Create a Form
Change Form View
Create a Form from a Template with Application Parts
Save a Form
Configure Form Controls
Move Form Controls
Add Form Controls
Remove Form Controls
Set Form Control Properties
Modify Data Sources
Manage Labels
Add Sub-Forms
Format a Form
Modify Tab Order
Configure Print Settings
Sort Records by Form Field
Apply a Theme
Control Form Positioning
Insert Backgrounds
Insert Headers and Footers
Insert Images
Module Five Review Questions

Create Reports
Create a Report Based on the Query or Table
Create a Report by Using a Wizard
Create a Report in Design View
Configure Report Controls
Add Report Controls
Add and Modify Labels
Modify Data Sources
Add Calculated Fields
Group and Sort Fields
Format a Report
Format a Report into Multiple Columns
Change Report Orientation
Control Report Positioning
Format Report Elements
Insert Header and Footer Information
Insert Images
Apply Themes
Module Six Review Questions

Words from the Wise
Lessons Learned


There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.

Disclaimer: * Prices quoted are PER PERSON ** Lecture/On-Site Courses may be cancelled or rescheduled if minimum course numbers are not met. *** All prices are subject to change without notice. Whilst every effort is made to provide you with the most accurate, up-to-date information, occasionally an item may be incorrectly priced or a price may require updating due to circumstances outside of our control or if changes or improvements are implemented.