Skip to content | Change text size
 

Access module 2

Two day program

Target group:Academic and general staff who are interested in learning how to use Microsoft Access 2003 to create and manipulate databases
Group size:Minimum 5 - Maximum 12
Level 2 program:
  • Completion of Access module 1 and/or some experience in building an Access database
Schedule:
Date:Tuesday 2nd June & Wednesday 3rd June 2009
Time:9:30am - 4:30pm
Venue:Studio 7, Short Course Centre Bld 51, Clayton campus
Apply by:Tuesday 26th May 2009
Schedule:
Date:Monday 26th October & Tuesday 27th October 2009
Time:9:30am - 4:30pm
Venue:Studio 7, Short Course Centre Bld 51, Clayton campus
Apply by:Monday 19th October 2009
Cost: Monash Staff /Students-$340
Catering:Morning and afternoon tea will be provided.
To apply:On-line application form

Overview

Access module 2 is for the more experienced user of Access . The course re-visits all elements of Access module 1 with focus on advanced interface usage.

Intended Outcomes

To further develop Access database skills

Course Content

On completion of this course participants will be able to

  • understand table and query relationships and how they affect the integrity of your data
  • create aggregated queries
  • create action queries to make tables, update, append and delete records
  • create a form using Design View
  • create sophisticated forms with tab controls and sub-forms
  • produce reports with calculations
  • create a Crosstab query to analyse data in a table or query
  • create simple macros
  • use conditions in macros
  • create macros that are used with forms
  • create a macro for an option group to provide instant filtering
  • create and maintain multiple copies of a database file
  • protect your database files against unauthorised access
  • completely secure a database file and its objects so that unauthorised access is prevented

Learning Approach

  • Hands-on workshop
  • Practice exercises

Handouts

A booklet of notes will be provided.