Access 2010

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 to check your work.
9. Save the query with the name Will Query.