SQLConfiguration SQLConfiguration


Creating Queries  «Prev  Next»

Creating Query in Design view - Exercise

Creating a query in Design view


Create a query in Design view


Objective: Create a query in Design view.
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. Open the Consulting database and create a query in Design view (use the same database you used for the last exercise in this module). The query results should display project descriptions with hours worked and the dates when the hours were worked. This query should not group or summarize data.
  2. View the results of the query. (It is alright if your fields appear in a different order on the datasheet.) They should look like this figure.

Project Hours
Project Hours
  1. Close and save the query. Give it the name “Project Hours.”