Mr Lowe's Lessons...
Plough Farm
Database Instructions - Handling Data
Setting up the database and the first table for the
Guests' Details.
Plough Farm keeps information about its customers on a
database.
The next task for you 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 8 ICT folder and call it "plough
farm database"
-
Double Click on the Create Table in Design View button...
-
Set up the following fields on the table
-
Set the Customer 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
-
Phone No.
|
Auto Number
Text
Text
Text
Text
Text
Text
Text
|
Long Integer
4
10
12
40
15
8
15
|
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 IN A LESSON WELL DONE
Now Check the Next Lesson to
see what fields you need to have in the next Table
Your database will have FOUR Tables
in it when you have finally set it up...
BACK TO MAIN PAGE