University of Bristol Information Services document acc-t6
Using and designing
Aims and Learning Objectives
This course aims to provide participants with the basic skills necessary to develop a simple
Access 2003 database, and is also suitable for those using Access 97, 2000 or XP (2002).
Please note: this course is not suitable for those using Access 2007.
The core learning objectives for this course are to:
• gain an understanding of necessary relational database concepts;
• create and use tables and forms for data entry;
• set relationships between tables;
• import external data;
• create and use queries to manipulate the data;
• create reports to present the data in a clear format;
• create mailing labels.
Using and designing Access 2003 databases (acc-t6)
Using and designing Access 2003 databases (August 08)
If you have any comments or queries about this document mail firstname.lastname@example.org.
This document may be used wholly or in part by the academic community, providing suitable
acknowledgment is made. It may not be used for any commercial or profit-making purpose without
permission. © 2008 University of Bristol. All rights reserved.
If you are working in the training room the files you need are in C:\User\Access\Introduction
If you want to work through the practical tasks shown in this document on your own system, obtain
the necessary files from:
You will see a link next to Introduction to using Access 2003 saying Practice file. You need to
extract these files before you can use them.
To extract the practice files:
• Click on Practice file.
• Choose Save (Internet Explorer) or Save File (Firefox).
• If using Intenet Explorer browse to where you want to save the file and click on Save. If using
Firefox, click on Save File and check where th