Designing a Multi-Table Query

When designing an Access query it can be simple or more complex. In Access complex query guidlines let you do more with data.

Challenge!

  1. Open an existing Access database. If you want, you can use our Access 2013 sample database.
  2. Create a new query.
  3. Select the Customers and Orders tables to include in your query.
  4. Change the join direction to right to left.
  5. Add the following fields from the Customers table to your query:
    • First Name
    • Last Name
    • City
  6. Add the following fields from the Orders table to your query:
    • Notes
    • ID
  7. Set the following criteria:
    • In the Last Name field, type Like "Go*" to return only records with last names beginning with Go.
    • In the City field, type "Raleigh" to return only records with Raleigh in the City field.
    • In the ID field, type >=60 to return only records with an ID number greater than or equal to 60.
  8. Run the query. If you entered the query correctly, your results will include one record for a customer named Will Good. If not, click the View drop-down arrow on the Ribbon to return to Design view and check your work.
  9. Save the query with the name Will Query.