Access - Intermediate: Relational Databases & Reports

Course description

This course is not currently being run.

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

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

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.