Creating Queries  «Prev  Next»

Specifying Access Sort Order - Exercise

Specifying Access Sort order

Refine your Query

Objective: Refine your query by specifying a sort order and matching criteria.
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.
  1. Edit the Project Hours query to display only work for Network Consultants, Inc. done during the months of September and October.
  2. Sort the query by date using the Sort row in the query Design view.
  3. Save the query with a new name: Network Consultants Project Hours.
Remember, because the Company criterion contains punctuation, you need to enclose it in quotation marks so that it appears in the criteria row as:
Network Consultants,Inc.