Access Advanced

Course Description: 

Access Advanced is designed for the highly skilled Access user. The learner will build upon previous knowledge of the database objects as well as incorporate automation through macros to build even more of an end-user environment. Importing, exporting, and database administrative tools and management concepts are also covered. See below for more details on features taught based upon the Microsoft Office version.

Prerequisite: 
Access Basics and Intermediate or equivalent experience
Software Version: 
2016, 2013, 2010, 2007
Course Highlights: 

Access 2013 and prior version topics include:

  • SQL Statements
  • Creating Crosstab Queries
  • Creating Parameter Queries
  • Using Action Queries
  • Creating, Running and Modifying Macros
  • Attaching Macros to the Events of Database Objects
  • Creating Macros to Provide User Interaction
  • Creating Macros that Require User Input
  • Importing and Exporting Objects
  • Interacting with the XML documents
  • Linking Access Objects (SharePoint, Outlook)
  • Optimizing the Database
  • Protecting Databases
  • Setting Start-Up Options

Access 2016 topics include:

  • Advanced Form Types
  • Adding Controls and Graphics
  • Importing and Exporting Objects
  • Creating, Running and Modifying Macros
  • Attaching Macros to the Events of Database Objects
  • Creating Macros to Provide User Interaction
  • Creating Macros that Require User Input
  • VBA Alternative to Macros
  • Optimizing the Database
  • Protecting Databases
  • Creating a Switchboard
  • Setting Start-Up Options
Upcoming Classes: 
Tuesday, August 21, 2018 - 9:00am
Thursday, September 20, 2018 - 9:00am
Monday, October 22, 2018 - 9:00am
Friday, November 16, 2018 - 9:00am
Wednesday, December 19, 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