Loading...

Course Description

This course builds on the skills and concepts taught in Access 2016 (365) Level I. Students will learn how to normalize data, manage table relationships, and enforce referential integrity; work with Lookup fields and subdatasheets; create join queries, calculated fields, and summary values; add objects to forms and create advanced form types; print reports and labels; create and modify charts; and use PivotTables and PivotCharts.

Prerequisites

Access 2016 (365) Level I or equivalent

Course Outline

Designing a Relational Database

  • Relational Database Design
  • Create a Table
  • Create Table Relationships

Joining Tables

  • Create Query Joins
  • Relate Data Within a Table
  • Work with Subdatasheets

Using Data Validation

  • Use Field Validation
  • Use Form and Record Validation

Creating Advanced Queries

  • Create Parameter Queries
  • Summarize Data
  • Create Subqueries
  • Create Action Queries
  • Create Unmatched and Duplicate Queries

Organizing a Database for Efficiency

  • Data Normalization
  • Create a Junction Table
  • Improve Table Structure

Using Advanced Reporting Techniques

  • Include Control Formatting in a Report
  • Add a Calculated Field to a Report
  • Add a Subreport to an Existing Report

Notes

For more Computer Applications courses click here.

Loading...

Enroll Now - Select a section to enroll in

Section Title
Microsoft Access 2016 (365) Level II
Type
Lab
Days
M, T
Time
8:30AM to 2:30PM
Dates
Oct 19, 2020 to Oct 20, 2020
Schedule and Location
Contact Hours
10.0
Location
Delivery Options
Classroom  
Course Fee(s)
Fee + 15% HST non-credit $399.00
Section Notes
For the Discount, In-House Customized Training and Cancellation Policy related to this course click here.
Section Title
Microsoft Access 2016 (365) Level II
Type
Lab
Days
Th, F
Time
8:30AM to 2:30PM
Dates
Feb 18, 2021 to Feb 19, 2021
Schedule and Location
Contact Hours
10.0
Location
Delivery Options
Classroom  
Course Fee(s)
Fee + 15% HST non-credit $399.00
Section Notes
For the Discount, In-House Customized Training and Cancellation Policy related to this course click here.
Section Title
Microsoft Access 2016 (365) Level II
Type
Lab
Days
M, T
Time
8:30AM to 2:30PM
Dates
May 17, 2021 to May 18, 2021
Schedule and Location
Contact Hours
10.0
Location
Delivery Options
Classroom  
Course Fee(s)
Fee + 15% HST non-credit $399.00
Section Notes
For the Discount, In-House Customized Training and Cancellation Policy related to this course click here.
Required fields are indicated by .