Plough Farm Database Instructions - Handling Data

Setting up a Query that Chooses Fields from More than one Table

Having a relationship between tables allows you to set up a QUERY that will show fields from MORE THAN ONE TABLE

You can then use QUERIES to SEARCH and SORT records in your database.

Your next task is to set up a QUERY that will show the following fields from different tables:

All the tables Title, First Name, Surname and Address Fields from the table "tblcustomers"

AND

The Booking Number, Customer Number, Accommodation Type, Arrival Date, Departure Date, Number of Adults, Number of Children, Dog, Electricity Point, Cost of Holiday and Method of Payment fields from the table "tblbookings" 

• Open up your database from My Documents if you haven't already done so
• Go in to Queries and click Create query by using wizard
• When the wizard comes on the window select the "tblcustomers" table from the list

• Click the > button to choose the following fields one at a time: Title, First Name, Surname and Address fields from the "tblcustomers" Table
  
  Then select the "tblbookings" table and do the following
  
  
• Click the > button to choose the following fields one at a time:The Booking Number, Customer Number, Accommodation Type, Arrival Date, Departure Date, Number of Adults, Number of Children, Dog, Electricity Point, Cost of Holiday and Method of Payment fields from the "tblbookings" Table
• In the next window select "Detail" and then click Next
• Call the query "qrybookings" and select the option to open the Query in Design View before clicking Finish

The query will come up on to the screen in Design View.

We will make a form that links to this Query and then modify the form to make it easier to use...

See the next lesson to find out how...

BACK TO MAIN PAGE