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:

Level 2 Prime Property House
2 Woodward Street
Corner Lambton Quay & Woodward Street
Wellington

Dates

Date Time Cost
Wed 7 - Wed 7 August 10 am - 1 pm $205.00
Wed 28 - Wed 28 August 10 am - 1 pm $205.00

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