Upcoming events

Monday, 15th October 2018

Time: 9:30AM - 12:30PM
Location: Rm 104, Social Sciences North Building (Computer Training Suite)

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: Using a Relational Database

Course description

This module describes the benefits of using a relational database and introduces the concepts necessary for optimising data storage and for complex structured retrieval

Type of course

Hands-on computer course

Presenters

Peter Franz
Flinders University

Who should attend

For people who need to move beyond simple data manipulation to extracting complex information, and who wish to increase both effectiveness and efficiency in database work

What you will learn

Relational design versus flat files

  • data redundancy
  • relationships
  • creating links
The relationship window
  • relationship types
  • primary and foreign keys
  • data types
Using related tables in multi-table queries
Optimising with performance analyser

Prerequisites / assumed knowledge

Basic use of Access and an understanding of creating databases as in the introductory course