Access module 1

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 1 program:

Schedule:

Date:	Thursday 5th & Friday 6th March 2009
Time:	9:30am - 4:30pm
Venue:	Studio 7, Short Course Centre Bld 51, Clayton campus
Apply by:	Wednesday 4th March 2009

Schedule:

Date:	Wednesday 6th May & Thursday 7th May 2009
Time:	9:30am - 4:30pm
Venue:	Studio 7, Short Course Centre Bld 51, Clayton campus
Apply by:	Wednesday 29th April 2009

Schedule:

Date:	Monday 12th October & Tuesday 13th October 2009
Time:	9:30am - 4:30pm
Venue:	Studio 7, Short Course Centre Bld 51, Clayton campus
Apply by:	Monday 5th October 2009

Cost:

Monash Staff /Students-$330

Catering:

Morning and afternoon tea will be provided.

To apply:

On-line application form

Overview

This workshop will cover the basic requirements to create and use an Access database.

Intended Outcomes

To be able to create an Access database, store data, extract specific data using queries and present the data in a report format.

Course Content

On completion of this course participants will be able to:

start an exit from Access and understand what a database object is

understand some elementary database theory

design a database structure

set table relationships in a database

add records to a relational database

import data into an Access table from a variety of sources

work with records in a relational database

use a range of data validation techniques to protect data integrity

create simple queries using more than one table

create select queries for a relational database

add calculated fields to queries

add parameters to queries to capture criteria data

create forms using the Form Wizard

create reports using the Report Wizard

use the Switchboard Manager to create a menu system

access the computer's help system and safely work with a computer

Two day program