Access Intermediate

Course Description: 

The Access Intermediate course will introduce more in-depth skills used in database management, including table relationships and referential integrity. The learner will gain a thorough understanding of queries based upon multiple tables, along with enhancing data entry forms, and adding functionality to reports.

Prerequisite: 
Access Basics or equivalent experience
Software Version: 
2016, 2013, 2010, 2007
Course Highlights: 
  • Database Normalization
  • Relating Tables
  • Implementing Referential Integrity
  • Lookup Fields
  • Modifying Lookup Fields
  • Subdatasheets
  • Joining Tables in Queries
  • Calculated Fields
  • Summarizing and Grouping Values
  • Adding Unbound Controls
  • Adding Graphics
  • Adding Combo Boxes
  • Advanced Form Types
  • Creating Customized Headers and Footers
  • Printing Database Objects
  • Creating Labels
  • Charts in Forms
  • Charts in Reports
  • PivotTables
  • Modifying PivotTables
  • PivotCharts
  • PivotTable Forms
  • Adding Calculated Values
Upcoming Classes: 
Thursday, March 15, 2018 - 9:00am
Monday, April 16, 2018 - 9:00am
Friday, May 11, 2018 - 9:00am
Tuesday, June 12, 2018 - 9:00am
Wednesday, July 18, 2018 - 9:00am
Full Day Class Only $195.00
Full-day classes are weekdays from 9am to 4pm, unless otherwise specified. WE OFFER FLEXIBLE SCHEDULING, SO PLEASE REQUEST AN ALTERNATE CLASS DATE IF NEEDED!
Register Now