Access Advanced

Course Description: 

Access Advanced is designed for the highly skilled Access user. The learner will create complex queries and macros. SQL query capabilities of Access are briefly explored. Importing, exporting, and database administrative tools and management concepts are also covered.

Prerequisite: 
Access Basics and Intermediate or equivalent experience
Software Version: 
2016, 2013, 2010, 2007
Course Highlights: 
  • SQL and Access
  • Writing SQL Statements
  • Attaching SQL Queries to Controls
  • 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 Objects
  • Exporting Objects
  • Interacting with the XML documents
  • Linking Access Objects
  • Working with Windows SharePoint Services
  • Optimizing Resources
  • Protecting Databases
  • Setting Options and Properties
  • Hyperlink Fields
  • Working with Outlook 2007/2010
  • Creating the AutoKeys & AutoExec macros
  • Creating Macros for Data Transfer
Upcoming Classes: 
Thursday, December 14, 2017 - 9:00am
Thursday, January 18, 2018 - 9:00am
Tuesday, February 20, 2018 - 9:00am
Tuesday, March 20, 2018 - 9:00am
Monday, April 23, 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