Access - Accelerated Intermediate

Though previous attendance at our Introductory Access 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.

CREATING FORMS

  • Add titles, fields and labels
  • Edit and change the appearance of labels
  • Select, size, and move controls (objects)
  • Using your form

PRINTING REPORTS

  • Create, preview, print and save a report
  • Redesign the body of the report, header and footer
  • Grouping information
  • Total and subtotal figures
  • Creating standard letters and mailing labels

RELATING TABLES

  • Creating a relationship between tables
  • Setting Join Properties

ADVANCED FORM DESIGN

  • Showing data from more than one table
  • Using sub-forms and multirecord forms

ADVANCED QUERIES

  • The query window and joining tables
  • Including fields from more than one table

GRAPHING

  • Creating and printing graphs
  • Adding and editing graphs on the report

MACROS AND BUTTONS

  • Creating, saving and running a Macro
  • Making a button using OLE and adding a macro to it

IMPORTING DATA

  • Importing data from Excel

Though previous attendance at our Introductory Access 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.

CREATING FORMS

  • Add titles, fields and labels
  • Edit and change the appearance of labels
  • Select, size, and move controls (objects)
  • Using your form

PRINTING REPORTS

  • Create, preview, print and save a report
  • Redesign the body of the report, header and footer
  • Grouping information
  • Total and subtotal figures
  • Creating standard letters and mailing labels

RELATING TABLES

  • Creating a relationship between tables
  • Setting Join Properties

ADVANCED FORM DESIGN

  • Showing data from more than one table
  • Using sub-forms and multirecord forms

ADVANCED QUERIES

  • The query window and joining tables
  • Including fields from more than one table

GRAPHING

  • Creating and printing graphs
  • Adding and editing graphs on the report

MACROS AND BUTTONS

  • Creating, saving and running a Macro
  • Making a button using OLE and adding a macro to it

IMPORTING DATA

  • Importing data from Excel

Class Details

Venue:

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

Dates

Date Time Cost
Wed 31 - Wed 31 July 10 am - 1 pm $205.00
Wed 21 - Wed 21 August 10 am - 1 pm $205.00

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