Creating Queries  «Prev  Next»

Simple Query Wizard - Exercise

The Simple Query Wizard

Create a query with the Simple Query Wizard

Objective: Create a query in the Consulting database.
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. For this exercise you can use the Consulting database you created in the Building an Access Database course. If you did not complete the exercises in that course, open Consulting_02.mdb.
  2. Open the Consulting database and create a query using the Simple Query Wizard. The results of the query should provide the following information: How much time did I spend on each project in each month? (This query is very similar to the one created in the Simulation, except that it adds the date component.)
  3. When you select fields for this query, make sure to include the Date field from the Hours table. When Access sees the date field, it will add an extra window to the wizard that asks you if you want to group data by date. Choose to group by month.
  4. Save and name the query Monthly Hours by Project.