Mr Lowe's Lessons...
Showtime Database Instructions - Handling Data
Setting up the database and the first table for the
Member's Details.
Showtime Video Rentals keeps information about its customers
on a database.
Your next task is to set up a database for them to use
You will use the programme called Microsoft Access.
HOW TO START
-
Click on Start, All Programs, Core Programs and click on
Access...
-
Click on new data base and save it (N.B. You have to save
a database before entering data)
-
Save your database in your Yr 9 ICT folder and call it "showtime
database"
-
Double Click on the Create Table in Design View button...
-
Set up the following fields on the table
-
Set the Membership Number as the Primary Key Field
-
Save your table with the name "tblcustomers"
-
DO NOT ENTER ANY DATA ON TO YOUR TABLE
AT THIS STAGE
|
Field Name
|
Field Type
|
Field Length or Format
|
Customer Number
Title
First Name
Surname
Address
Town
Post code
Date of Birth
Phone No. |
Auto Number
Text
Text
Text
Text
Text
Text
Date / Time
Text
|
Long Integer
4
10
12
40
10
8
15
14
|
Points to Learn
-
Information is held in a table in a database
-
A database can have more than one table
-
The Rows in a table are called Records
-
The Columns in a Table are called Fields
IF YOU GET THIS FAR IN A LESSON WELL DONE
Now Check the Next Lesson to
see what fields you need to have in the next Table
BACK TO MAIN PAGE