Theatre Topic - An Employees Database

This project looks at how ICT could be used in the context of a Theatre.

Task-Your next task is to set up a database for the theatre to keep records about their employees.

Here is a step by step guide

Load up the Microsoft Access Database (Start / All Programs / Core Programs / Microsoft Access)
Click on Create a new file from the right hand task pane
Then click on Blank Database at the top of the list in the next task pane
Save it in your Yr9 ICT folder with the name "theatre workers database"

You are now ready to set up the 2 tables which are listed below.

I have highlighted the primary key fields in each table with yellow text.
 

Fields in the Title table

Double click set up table in Design view as in the picture below

This first table will only have 1 field which will contain titles that will be shown in a drop down menu in the main table that you will set up later

The details of the title field are shown below. See the picture to see how to set up the title field in Design View 

The picture below shows how to enter the above information in the correct places. Note that I have made this field the primary key. You can see a tiny key just to the left of the field name.

When you have set up this table click on the save icon on the top tool bar and save the table with the name tbltitle like in the picture below.

When you have saved the title table you can double click it and enter the following titles as in the picture below.

Next you need to set up the Fields in the Employees' Table

Fields that need to be set up in the Employee Details Table are as follows

You start by double clicking "Create Table in Design View"

In design view you have to set up the following fields.
 

When you have finished setting up the above fields you need to save this table with the name tblemployees

When you get to this stage you should have a table set up with a list of titles in it and a blank table ready to hold employees' details

The next stage is to make the title field in the employees' table look up the list of titles in the title field.

However - we will look at how to do that on the next instruction page...

BACK TO MAIN PAGE