Final answer:
To create a query in the design view, add the registration fee, guest fee, and workshop fee fields to the grid, toggle the Total Row, select 'Sum' for each field to calculate their sums, and save the query as 'Aggregate Fees'.
Step-by-step explanation:
To create a query in the design view for a registration table with specific criteria in Microsoft Access, you would follow these steps:
- Open the Access database and go to the 'Create' tab to click on 'Query Design'.
- In the query design grid, add the registration fee, guest fee, and workshop fee fields by double-clicking each field from the registration table listed in the 'Show Table' dialog box.
- To calculate the sum of each of the three fields, you would need to add a Total Row. You can do this by toggling the 'Totals' button in the toolbar, which will add a 'Total' row to the grid.
- In the newly added Total Row, select 'Sum' from the dropdown for each of the three fields to calculate their sums.
- Once your query setup is complete, save the query with the name 'Aggregate Fees' by clicking the save icon and entering the name when prompted.
The final query will calculate the sum of the registration fee, guest fee, and workshop fee for you.