Access - Advanced

Take your Microsoft Access skills to the next level with our comprehensive advanced course designed for individuals aspiring to become Access experts. Dive deep into the advanced functionalities of this powerful database software and unlock the full potential of database development and optimization.

In our advanced Access course, you will delve into advanced topics and techniques that will enable you to design, build, and optimize robust databases. Gain in-depth knowledge of advanced query design, database normalization, advanced form and report customization, and automation through macros.

Discover how to create efficient and scalable database solutions, improve performance through query optimization, implement advanced security measures, and integrate Access with other data sources and applications. With our expert guidance and hands-on exercises, you'll develop the skills to tackle complex database challenges and optimize your Access solutions for maximum efficiency.

Learn how to streamline data entry, design interactive forms, generate dynamic reports, and automate repetitive tasks to enhance productivity. By mastering advanced Access techniques, you'll become a proficient database developer and gain a competitive edge in the field of data management.

Join our advanced Access course today and unlock the full potential of this powerful database software. Book now to embark on a transformative learning journey that will make you an Access expert and equip you with the skills to design and optimize robust databases. Discover the power of Access and become a master of advanced database development and optimization.


  • A quick revision of the basic topics.


  • Select Queries
  • Aggregate (Total) Queries
  • Crosstab Queries
  • Action Queries
  • Make Table Queries
  • Append and Delete Queries
  • Update Queries


  • Definition of Expressions
  • Calculated Fields in Forms
  • Calculated Fields in Reports


  • Creating Macros
  • Using Macro Groups
  • Attaching Macros
  • Order of Events
  • Custom Menus
  • Autoexecute Macros
  • Debugging Macros

Class Details

3 hours 10am - 1pm or 1:30 - 4:30
4 or more people - $150 + GST (per person)
3 people - $175 + GST (per person)
1 or 2 people - $205 + GST (per person)
Evening Class 2½ hours 5:30pm - 8:00pm $90 + GST

At Your Site

4 or more people - $225 + GST (per person)
3 people - $250 + GST (per person)
2 or fewer people - $275 + GST (per person)


Upcoming Sessions

Dates don't suit? Call or E-mail.