Learning Outcomes
By the end of this course students will be able to:

Determine the requirements and relationships of a basic database
Develop the necessary tables and relationships to store data
Create queries to manipulate data

Method
This course is provided as hands on and includes and extensive workshop manual and data disk for use during the course.

Planning Your Design

Starting Access
Creating a database
The Access screen and database window
Planning your design
Identifying your tables
Determining the fields for each table
Determining the primary keys
Determining relationships between tables
Optimising your database design
Implementing your design

Sorting Data Using Tables

Creating a table
Setting field properties
Creating table relationships
Entering and manipulating data in tables

Querying Tables

Viewing and extracting data
Testing and running your query
Refining your data selection
Operators and functions
Expression examples
Editing your query
Simple calculations in a query
Simple functions in a query