Upcoming events

No upcoming events

Please remember if you can't attend a course anymore please unenrol yourself or move to the waiting list so others can attend.

Waiting list

To be notified of upcoming events, you can add your name to the waiting list.

Access - Intermediate: Forms & Queries

Course description

This module expands the knowledge acquired in the Relational Database course by exploring the detailed workings of two types of database objects. From this, you will begin to appreciate how Access can unlock your data by flexible and productive means, and understand what appropriate relationships can accomplish.

Type of course

Hands-on computer course

Presenters

Peter Franz
Flinders University

Who should attend

For people who can confidently create a simple database (with tables, queries, and forms), and who wish to extend the usefulness and functionality of their applications, and improve ease of use.

What you will learn

More advanced queries
Query types

Select queries
Parameter queries
Action queries
Join types
Calculated fields
Multi-table queries

More advanced forms
Working with controls

Combo boxes
Option groups
Control properties
Main forms & sub-forms
Multiple form pages

Prerequisites / assumed knowledge

Attended Introduction to Access or good knowledge of Access