Access 2013 / 2016 - Intermediate Training

Overview

Rating:
Duration:
( - Eastern)
Cost:
$285.00
Access 2013 / 2016 - Intermediate Logo
This course builds on the skills and concepts taught in the Introduction course. Students will learn relational database concepts and techniques, advanced queries, advanced form and report building, and how to create charts. This course will help students prepare for the Microsoft Office Specialist exam for Access 2016. For comprehensive certification training, students should complete the Introduction, Intermediate, and Advanced courses for Access.

Live Online Schedule

  • Dec 6
  • Jan 14
  • Feb 15
  • Mar 22

Prerequisites

Microsoft Access 2013 / 2016 - Introduction or equivalent knowledge.

Requirements

You will need the following software/setup for this class:

  • Microsoft Office 2013 or higher

Topics

Access 2013 / 2016 - Intermediate

  • Relational databases
    • Database normalization
    • Table relationships
    • Referential integrity
  • Related tables
    • Creating lookup fields
    • Modifying lookup fields
    • Subdatasheets
  • Complex queries
    • Joining tables in queries
    • Using calculated fields
    • Summarizing and grouping values
  • Advanced form design
    • Adding unbound controls
    • Graphics
    • Adding calculated values
    • Adding combo boxes
    • Advanced form types
  • Reports and printing
    • Report formatting
    • Calculated values and subreports
    • Printing
    • Label printing
  • Charts
    • Charts in forms
    • Charts in reports