You will receive 5 points for this exercise. The exercise is auto-scored, which means all you need to do to receive full credit
is click the Submit button.
In the text box below, write the steps you would follow in
Access 365 to create a query using the
Simple Query Wizard that answers this business question:
How much time did I spend on each project in each month?
Your step list should include:
- How you open the Consulting database (your local copy).
- How you launch the Simple Query Wizard.
- Which tables (or table/query) you would choose as the source.
- Which fields you would add, including the Date field from the Hours table.
- How you choose to group by Month when prompted by the wizard.
- How you summarize the time (for example, Sum of Hours).
- How you name and save the query as Monthly Hours by Project.
Keep your answer concise, but specific enough that another student could follow your steps.