Dal Alert!

Receive alerts from Dalhousie by text message.

X

Microsoft Access 2016 (365) Level II

Upcoming Dates

February 12-13, 2018

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

Content

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