Showtime 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 Fields from the table "tblcustomers"

AND

All the Fields from the table "tblvideos"

AND

All the 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 all the fields from the "tblcustomers" table
  
  Then select the "tblbookings" table and do the following
  
  
• Click the >> button to choose all the fields from the "tblbookings" table
  
  Then select the "tblvideos" table and do the following
  
  
• Click the >> button to choose all the fields from the "tblvideos" 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. You can just close this query down now.

We will now make a booking 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