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: 
Tuesday, March 20, 2018 - 9:00am
Monday, April 23, 2018 - 9:00am
Thursday, May 24, 2018 - 9:00am
Friday, June 22, 2018 - 9:00am
Wednesday, July 25, 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