Access Intermediate

Course Description: 

Access Intermediate introduces more in-depth skills used in database management including table relationships and referential integrity. The learner will gain a more thorough understanding of the database objects to build additional functionality into the database. See below for more details on features taught based upon the Microsoft Office version.

Prerequisite: 
Access Basics or equivalent experience
Software Version: 
2019, 2016, 2013, 2010
Course Highlights: 

Access 2013 and prior version topics include:

  • Database Normalization
  • Relating Tables
  • Implementing Referential Integrity
  • Lookup/Drop-Down Fields
  • Subdatasheets
  • Joining Tables in Queries
  • Calculated Fields in Queries, Forms and Reports
  • Advanced Form Types
  • Adding Controls and Graphics
  • Advanced Report Customization
  • Managing Report Sections
  • Summarizing and Grouping Values in Reports
  • Charts in Forms and Reports
  • PivotTables in Access

Access 2016 topics include:

  • Database Normalization
  • Relating Tables
  • Implementing Referential Integrity
  • Joining Tables in Queries
  • Subdatasheets
  • Data Validation
  • Creating Crosstab Queries
  • Creating Parameter Queries
  • Using Action Queries
  • Advanced Report Customization
  • Calculated Fields in Queries and Reports
Upcoming Classes: 
Tuesday, October 9, 2018 - 9:00am
Thursday, November 8, 2018 - 9:00am
Wednesday, December 12, 2018 - 9:00am
Friday, January 18, 2019 - 9:00am
Tuesday, February 12, 2019 - 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