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

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 - $195 + GST (per person)
Evening Class 2½ hours 5:30pm - 8:00pm $90 + GST

Venue:

Level 2 Primeproperty House
2 Woodward Street
Corner Lambton Quay & Woodward Street
Wellington

Dates


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