Description

The opportunity Access 2003 - An overview of relational databases helped you understand why some databases need more than one table. This opportunity will help you to use Access to investigate how to create a relational database. If you are not clear why some databases need more than one table you should complete the self study opportunity Access 2003 - An overview of relational databases before going any further. In this unit you will start by designing the database on paper to make sure that you set the correct table structure and relationships. Once you are happy that your tables hold the correct fields you can then set the appropriate key fields and create the relationships between the tables.

Content:

1. Be able to design a relational database
2. Be able to define the correct relationships between tables
3. Understand what is meant by referential integrity
4. Be able to change the properties of a field
5. Be able to use a form to enter data into the database

Level: Proficient users

Audience: All education staff

Pre Skills: Mastery of the skills covered in Level 0/1 Microsoft Access courses

Hardware: Personal computer (PC)

Software: Microsoft Access 2003