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
Build forms for efficient data entry
Create reports
Use productivity tools to automate your database & analyse your data

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

Introduction to Microsoft Access 2000

What is Access
Exploring an Access Database
The Access Screen and the Database Window

Planning and Designing a Database

Planning a Database
Designing a Database

Creating a New Database

Creating a database using the wizard
Creating a blank database

Creating Tables to Store Data

Creating new fields in Design view
Design view versus Database view
Managing tables

Creating Table Relationships

Creating table relationships
Modifying table relationships

Entering and Viewing Data in Tables

Entering and manipulating data in tables
Using Subdatasheets
Timesaving tools

Analysing Data Using Queries

Viewing and extracting data
Types of queries
Creating a query in Design view
Multiple table queries

Using Selection Criteria in Queries

Refining your data selection
Hiding fields in a query

Creating Calculated Fields in Queries

Simple calculations in a query
Combining fields in a query
Further limiting your query

Creating Forms to View and Edit Data

Why use forms?
Creating a form
Saving changes to the design
Creating a form and subform

Editing Data Using Forms

Entering data into forms
Sorting data in forms
Finding data in forms
Replacing data in forms
Useful shortcuts

Customising Forms

Modifying the design of a form
Sections in a form
Inserting additional controls

Working With Reports

Why use reports?
Creating a report
Printing and Previewing your data
Positioning controls