Mr Lowe's Lessons...
Plough Farm
Database Instructions - Handling Data
Setting up the third table that holds Accommodation
Details
Plough Farm keeps information about what accommodation
the guests have in their database.
The second table for youto set up on your database is for accommodation
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 Accommodation Type as the Primary Key Field
- Save your table with the name "tblaccommodation"
-
DO NOT ENTER ANY DATA ON TO YOUR TABLE
AT THIS STAGE
|
Field Name
|
Field Type
|
Field Length or Format
|
-
Accommodation type
-
Accom Description
-
Price
-
Charge period
|
Text
Text
Currency
Text
|
20
255
2 decimal places
12
|
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 2 TABLES IN YOUR DATABASE
Now Check the Next Lesson to see what
to do next
BACK TO MAIN PAGE