Estate Agent's Topic - Setting up a House Database

The first thing to do is to load up the Microsoft Access program. When it loads up click on "Create New File" in the right hand help pane and then click on "Blank Database". Call the file "House Database" and save it in your yr8 ict folder.

The First thing that you have to do on a new database is set up any tables to hold information. the house database will have TWO tables.

• Double click "Create Table in Design View"
• Set up the following field and make it the primary key field.

When you have created this table click on the disc ikon to save it and give it the name "tblhousetype"

Then open this table in "datasheet view" and enter the following records:
 

Table 2 - This will have 27 fields

• Double click "Create Table in Design View"
• Set up the following fields and make the "house ID" field as the primary key.

Make sure that there are NO mistakes when you set up the fields
 

You are now ready to set up the type of house field as a look up field...

See the next lesson for details.
 

BACK TO MAIN PAGE