Access - Accelerated Advanced

A fast pace is maintained with time allowed to recap various topics and to demonstrate new tips and techniques. Though previous attendance at our intermediate course is assumed those with a comparable understanding are welcome to enrol. Please call a course administrator for clarification.


REVISION

  • A quick revision of the basic topics.

QUERIES

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

USING EXPRESSIONS

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

MACROS

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

Class Details

Venue:

Dates


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