Access Intermediate (2013, 2016, 2019, Office 365) Training

Overview

Rating:
Duration:
( - Eastern)
Cost:
$285.00
Access Intermediate (2013, 2016, 2019, Office 365) 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 comprehensive certification training, students should complete the Introduction, Intermediate, and Advanced courses for Access.

If you need customized content or another version of this course please contact us.

Live Online Schedule

  • Feb 15
  • Mar 22
  • Apr 9
  • May 2
  • Jun 11

Prerequisites

Microsoft Access Introduction or equivalent knowledge.

Requirements

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

  • Microsoft Office 2013 or higher

Topics

Access Intermediate (2013, 2016, 2019, Office 365)

  • 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