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

Web conference

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