ITS Home
IT Training
- Face-to-Face Courses
- Book a Face-to-Face Course
  - Booking Policy & Training Costs
- Online Courses Office 2007 & Office 2003
  - Microsoft Office 2003
  - Microsoft Office 2007
- Book an Online Course
- Further Information
- Training Staff

ITS Helpdesk
Phone: 8303 3000

Telecommunications
Phone: 8303 3333

Online Education
Phone: 8303 3335

Audio Visual Support
Phone: 8303 3933

Information Technology
Services
Level 9, 9 Gawler Place
The University of Adelaide
SA 5005 Australia

Email
Phone: +61 8 8303 5716
Facsimile: +61 8 8303 4400

Access 2003

The following units are recommended for Microsoft Certified Application Specialist certification:
Access 2003: Level 1
Access 2003: Level 2
Access 2003: Level 3
Access 2003: Level 4

There is currently no face-to-face training available for Access 2007.

The sample files used in all general Microsoft Office courses are available for download by clicking here. Our licence agreement restricts access to staff and students who have completed the relevant courses.

Access 2003: Level 1

Target Audience

This unit is aimed at staff and students looking for an introduction to Access 2003.

Prerequisite and Co-requisite Courses

This is the entry level course for Access 2003. The knowledge and skills covered in this unit will be assumed in the subsequent units.

Course Duration

3.5 hours.

Competencies

At the completion of the course, attendees will be able to:

Explore Access
Create tables
Work with tables
Print data from a table
Modify tables
Set the properties of fields in tables
Create relationships between tables in a database
Edit tables

Access 2003: Level 2

Target Audience

This unit is aimed at staff and students with a basic understanding of database tables and who want to know more about creating and developing queries in multi-table databases

Prerequisite and Co-requisite Courses

This course assumes knowledge of all items covered in Microsoft Office Specialist: Access 2003: Level 1. The knowledge and skills covered in this unit will be assumed in the subsequent units.

Course Duration

3.5 hours.

Competencies

At the completion of the course, attendees will be able to:

Find and filter data
Use simple queries to retrieve information
Modify query results
Use a variety of operators in queries
Design advanced queries with calculated fields and functions

Access 2003: Level 3

Target Audience

This unit is aimed at staff and students wanting to increase their skills in creating forms.

Prerequisite and Co-requisite Courses

This course assumes knowledge of all items covered in Microsoft Office Specialist: Access 2003: Level 1 and Microsoft Office Specialist: Access 2003: Level 2. The knowledge and skills covered in this unit will be assumed in the subsequent unit.

Course Duration

3.5 hours.

Competencies

At the completion of the course, attendees will be able to:

Create basic forms
Manipulate controls in a form design
Use design view with a form
Use advanced form design to add combo boxes and list boxes
Use editing tools for formatting forms

Access 2003: Level 4

Target Audience

This unit is aimed at staff and students wanting to increase their skills in developing reports and to obtain advanced skills in managing databases.

Overview

This unit covers the creation of reports to retrieve information from a database and a variety of techniques used for managing databases, and is suitable for people with an knowledge of creating multi-table databases with related queries and forms.

Prerequisite and Co-requisite Courses

This course assumes knowledge of all items covered in Microsoft Office Specialist: Access 2003: Levels 1 to 3.

Course Duration

3.5 hours.

Competencies

At the completion of the course, attendees will be able to:

Create basic reports
Use advanced report design
Use advanced database features
Use Access and the internet
Export data to Excel or Word