Designing a Query

When designing an Access query it can be simple or more complex. In Access simple query guidelines let you pull important data.

Challenge!

  1. If you haven't already, download our sample database and open it.
  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.