Access Advanced

Course Description

Microsoft Access Advanced

icon_accessThis class covers advanced concepts in Microsoft Access and is designed for students with significant Access experience.

Access Advanced Training Class Goal

Students will come from this class feeling confident with the advanced features in Microsoft Access and will be able to develop complex detailed databases.

PreRequisites

Familiarity with creating databases in Microsoft Access.

Topics Covered

  • SQL and Access
  • Writing SQL statements
  • Attaching SQL queries to controls

Advanced Queries

  • Creating Crosstab queries
  • Creating parameter queries
  • Using Action queries

Macros

  • Creating, running, and modifying macros
  • Attaching macros to the events of database objects

Advanced Macros

  • Creating macros to provide user interaction
  • Creating macros that require user input
  • Creating the AutoKeys and AutoExec macros
  • Creating macros for data transfer

    Importing, Exporting, and Linking

  • Importing objects
  • Exporting objects
  • Interacting with XML documents
  • Linking Access objects

    Database Management

  • Optimizing resources
  • Protecting databases
  • Setting options and properties
  • Navigation and tabbed forms
  • Switchboards
  • Splash screens
  • Read-only forms

    Internet Integration

  • Hyperlink fields
  • Working with Outlook 2007 or later

Upcoming Classes

Access Advanced
Oct 1 8:00 am - 4:00 pm Access Advanced Phoenix Access Advanced Access Advanced Training in Denver & Phoenix Class Price: $410 What’s included – a $900 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 01-10-2018T08:00 01-10-2018T16:00 Active
Active 01-10-2018 Active 410.00 01-10-2018
Register Now
Access Advanced
Nov 14 8:00 am - 4:00 pm Access Advanced Westminster Access Advanced Access Advanced Training in Denver & Phoenix Class Price: $410 What’s included – a $900 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 14-11-2018T08:00 14-11-2018T16:00 Active
Active 14-11-2018 Active 410.00 14-11-2018
Register Now
Access Advanced
Mar 6 8:00 am - 4:00 pm Access Advanced Phoenix Access Advanced Access Advanced Training in Denver & Phoenix Class Price: $450 What’s included – a $980 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 06-03-2019T08:00 06-03-2019T16:00 Active
Active 06-03-2019 Active 450.00 06-03-2019
Register Now
Access Advanced
May 6 8:00 am - 4:00 pm Access Advanced Tech Center Access Advanced Access Advanced Training in Denver & Phoenix Class Price: $450 What’s included – a $980 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 06-05-2019T08:00 06-05-2019T16:00 Active
Active 06-05-2019 Active 450.00 06-05-2019
Register Now
Access Advanced
Sep 20 8:00 am - 4:00 pm Access Advanced Phoenix Access Advanced Access Advanced Training in Denver & Phoenix Class Price: $450 What’s included – a $980 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 20-09-2019T08:00 20-09-2019T16:00 Active
Active 20-09-2019 Active 450.00 20-09-2019
Register Now
Access Advanced
Oct 28 8:00 am - 4:00 pm Access Advanced Westminster Access Advanced Access Advanced Training in Denver & Phoenix Class Price: $450 What’s included – a $980 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 28-10-2019T08:00 28-10-2019T16:00 Active
Active 28-10-2019 Active 450.00 28-10-2019
Register Now

Bookings are closed for this class.

Live & In-Person

All of the classes on this page are taught by live instructors who are present in the classroom.