Showtime Video Rentals - Employee Database Instructions

Mr Lowe's Lessons...

Showtime Employee Database Instructions - Handling Data

Setting up an employee database

Showtime has expanded and has several shops.

The company keeps information about its workers and jobs they do on an database.

Your next task is to set up a database for them to use

You will use the programme Microsoft Access.

HOW TO START

Click on Start, All Programs, Core Programs and click on Access...
Click on "Create a Nw file"
Then click on "Blank database"
Save your database in your Yr 9 ICT folder and call it "showtime employees" (N.B. You have to save a database before setting up the tables)
Double Click on the Create Table in Design View button...
Set up the following 2 tables

On this first table you need to:

Set the Job Code as the Primary Key Field
Save your table with the name "tbljobdescription"

Field Name	Field Type	Field Length or Format
Job Code Job Title Job Description	Text Text Text	5 25 255

Set up second table with the following fields

Set the Reference Number as the Primary Key Field
Make the Job Code field a Look Up field and use the Look Up wizard to make it look up the Job Code field in the "tbljobdescription" table
Save your table with the name "tblemployees"

DO NOT ENTER ANY DATA ON TO YOUR TABLE AT THIS STAGE

Field Name	Field Type	Field Length or Format
Reference Number First Name Surname Title Address Post code Phone No. Date Started Job Code	Anto Number Text Text Text Text Text Text Date / Time Look Up Field (Text)	Integer 15 15 4 40 8 15 Short Date 5

Relationship

If you have made a look up field as described above the relationship will have been made automatically.
However, click on the relationship like with the right hand button and tick the Referential Integrity box...
Here is a picture of the relationship window after the box has been ticked.

Double click the "tbljobdescription" table and populate it with the correct data.

Click here to get the data that you need jobs table.

Once you get to here you can enter the data in to the Employees' table using a Form.

Create a form linked to the "tblemployees" table and use it to enter all the workers' details.

Click here to get the employees details that you use to populate the database

Well done. You have worked well to get to here.

BACK TO MAIN PAGE