Mr Lowe's Lessons...
Showtime Database Instructions - Handling Data
Setting up the Second Table for the Video Details
Showtime Video Rentals also keeps information about its
videos on the database.
Your next task is to set up a second table on your database
to hold video details
HOW TO START
-
Open up your database from My Documents
-
Double Click on the Create Table in Design View button...
-
Set up the following fields on the second table
-
Set the Video Reference number as the Primary Key
Field
-
Save your table with the name "tblvideos"
-
DO NOT ENTER ANY DATA ON TO YOUR TABLE
AT THIS STAGE
|
Field Name
|
Field Type
|
Field Length or Format
|
-
Video Reference Number
-
Title
-
Category
-
Certificate
-
Price Code
|
Auto Number
Text
Text
Text
Text
|
Long Integer
80
3
2
1
|
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
Now Check the Next Lesson
to see what you have to do...
BACK TO MAIN PAGE