Estate Agent's Topic - Setting up a House Database

You are now ready to set up a...

 SET UP A QUERY...

A "QUERY" is used to search through information on a database

• Click on the "queries" tab

• Double click "create query in design view"

• Click the "houses" table in the "Show Table window" and then click the "add" button

• Close the Show Table window

• Then select all the fields in the houses table
• Then drag all those fields on to the white grid below
• Then in the Criteria Row under the "House Type" field write [Enter House Type]
• Save this query as "qryhousetypesearch"

Close the query down. Then Double Click the query... What happens?

You can now make a form that links to this query...

BACK TO MAIN PAGE