Question

13. Open the AveragePremium query in Design View and perform the following tasks: a. Add a Totals row to the design grid. b. Select Avg as the calculation in the Total row. c. Set the caption to Avg Prem for the Premium field. Save the changes to the query. Open the query in Datasheet View and confirm that it matches Figure 2. Close the query, saving if necessary. Figure 2: AveragePremium query results

          13. Open the AveragePremium query in Design View and perform the following tasks:
a. Add a Totals row to the design grid.
b. Select Avg as the calculation in the Total row.
c. Set the caption to Avg Prem for the Premium field.
Save the changes to the query. Open the query in Datasheet View and confirm that it matches Figure 2. Close the query, saving if necessary.
Figure 2: AveragePremium query results

13. Open the AveragePremium query in Design View and perform the following tasks:
a. Add a Totals row to the design grid.
b. Select Avg as the calculation in the Total row.
c. Set the caption to Avg Prem for the Premium field.
Save the changes to the query. Open the query in Datasheet View and confirm that it matches Figure 2. Close the query, saving if necessary.
Figure 2: AveragePremium query results

Added by Jose Carlos V.

Computer Science and Information Technology

Trishna Knowledge Systems 2018 Edition

Instant Answer

Solved by Expert Aaron Goree

Step 1

Certainly! Here's a step-by-step guide to modifying the "AveragePremium" query in a database management system like Microsoft Access: Show more…

Show all steps

Thanks for your feedback!

Open the AveragePremium query in Design View and perform the following tasks: a. Add a Totals row to the design grid. b. Select Avg as the calculation in the Total row. c. Set the caption to Avg Prem for the Premium field. Save the changes to the query. Open the query in Datasheet View and confirm that it matches Figure 2. Close the query, saving if necessary.