This is Steps $11-14$ from my last question for Microsoft Access Assignment as it only let me post Steps $1-10.$

$11.$ Modify the Renters Premium List Report by performing the following tasks:

a$.$ Open the Renters Premium List Report in Design View.

b$.$ Use the Group, Sort, and Total pane to add a footer section to the Group on CustomerID section.

c$.$ Add a text box control in the CustomerID Footer section.

d$.$ Convert the text box control into a calculated control that averages the Premium field. $($Hint: Your control should contain the formula $=$Avg$([$Premium$]).)$

e$.$ Format the control so that it displays with the Currency number format and two decimal places.

f$.$ Change the label using Average Premium as the label name.

g$.$ Reposition the control and its label to the approximate location shown in Figure $6.($Hint: The left edge of the text box should be located at the $5"$ mark on the horizontal ruler.$)$

$12.$ Create a new blank report in Design View, and then complete the following tasks:

a$.$ Open the Property Sheet for the report, and then apply the Record Source for the report to the Claims table.

b$.$ Save the report with the name Basic Claims Report, but do not close the report.

c$.$ Add the ClaimID, CustomerID, and PolicyNumber fields to the report and then reposition them so that the left edges of the three controls are at the $3"$ mark on the horizontal ruler and only a single dotted line separates the labels and controls vertically.

d$.$ Add the title Basic Claims Report to the Report Header section.

e$.$ Add page numbers to the report at the Top of Page $($Header$)$ position, using the Page N of M format and Right alignment.

$13.$ Open the NE Homeowners by State Report in Design View. Group the report by the State field, and then sort the report by the CustomerID field in ascending order. Do not add any additional grouping or sorting options to the report. Save and close the NE Homeowners by State Report. $($Hint: This report does not contain any fields.$)$

$14.$ Modify the Claims Total Report by performing these tasks:

a$.$ Open the Claims Total Report in Design View.

b$.$ Add a text box control to the Report Footer section. The left edge of the control $($not the label$)$ is at the $5"$ mark on the horizontal ruler.

c$.$ Convert the text box control into a calculated control that sums the ClaimAmount field. $($Hint: Your control should contain the formula $=$Sum$([$ClaimAmount$]).)$

d$.$ Format the control so that it displays with the Currency number format and zero decimal places.

e$.$ Change the label using Total as the new label name.

f$.$ If necessary, reposition the control and its label so that the left edge of the text box is located at the $5"$ mark on the horizontal ruler.

Confirm that the report matches Figure $8,$ and then save and close the Claims Total Report