Mr Lowe's Lessons...
Plough Farm
Database Instructions - Handling Data
Setting up the second table that holds Booking Details
Plough Farm keeps information about customers' bookings
on its database.
The next task for you is to set up a second table on your
database for booking details.
HOW TO START
-
Open up your Plough Farm database from My Documents
-
Double Click on the Create Table in Design View button...
-
Set up the following fields on the table
-
Set the Booking Reference Number as the Primary Key Field
-
Save your table with the name "bookings table"
-
DO NOT ENTER ANY DATA ON TO YOUR TABLE
AT THIS STAGE
|
Field Name
|
Field Type
|
Field Length or Format
|
-
Booking Number
-
Customer Number
-
Accommodation Type
-
Arrival Date
-
Departure Date
-
Number of Adults
-
Number of Children
-
Dog
-
Electricity Point
-
Cost of Holiday
-
Method of payment
|
Auto Number
Number
Text
Date / Time
Date / Time
Number
Number
Yes / No
Yes / No
Currency
This will be a look up field
|
Long Integer
Long Integer
20
Short Date
Short Date
Integer
Integer
2 decimal places
15
|
The method of payment field is a look up field. You will make
it look up the recoreds in the table called "tblmethodofpayment"
Points to Learn
-
Information is held in tables on 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 YOU SHOULD HAVE TWO EMPTY TABLES
IN YOUR DATABASE
Now Check the Next Lesson to see what
you have to do next
Your database should have 4 tables on
it now...
BACK TO MAIN PAGE