Mr Lowe's Lessons...



Showtime Database Instructions - Handling Data

Setting up the Third Table for the Video Bookings
 

Showtime Video Rentals also keeps information about who has rented Videos on a third table in it's database.

Your next task is to set up a this third table on your database to hold details about these rentals.
 
 

HOW TO START


 
Field Name
Field Type
Field Length or Format
  1. Rental Number (Primary Key)
  2. Video Reference No. 
  3. Date Out
  4. Date In
  5. Membership Number
Auto Number
Number
Date/Time
Date/Time
Number
Long Integer
Long Integer
Short Date
Short Date
Long Integer

 

Now Check the Next Lesson to see how to set up relationships between tables...

NOTE: It is generally best to set up relationships before entering any data into your tables.




BACK TO MAIN PAGE