Creating Queries  «Prev  Next»

Editing a query design - Exercise

Editing a query design


Edit a query


Objective: Edit the Project Hours query.
You will receive 5 points for this exercise. The exercise is auto-scored, which means all you need to do to receive full credit for the exercise is click the Submit button.
Make the following changes to the Project Hours query you created in the last exercise:
  1. Add the Clients table to the query.
  2. Add the Company and Last Name fields to the query.
  3. Put the fields in the query in this order: Last Name, Company, Project Description, Date, Hours worked.
  4. View the results.
  5. Return to Design view.
  6. Delete the Last Name field.
  7. Save and close the query.