d$.$ Join the Customers table and the Renters table by drawing a line from the CustomerID field in the Customers table to the CustomerID field in the Renters table. $($Hint: Because the field names are identical in both tables, the line may already be there. Do not attempt to recreate the line if it is already present.$)$

e$.$ Save the query using Customer$-$Renter as the name.

Open the query in Datasheet View, then close it$,$ saving if necessary.

$10.$ Because customers live in different states, it is often advantageous to create a query where you can change one criteria using a parameter query. Open the StatesParameter query in Design View.

a$.$ Add parameter criteria to the State field to replace the current $"$FL$"$ criteria. The new parameter criteria should prompt the user with Enter desired state as the text.

b$.$ Save the changes to the query.

c$.$ View the query in Datasheet View. Enter PA when prompted.

Confirm that $8$ records appear in the query results then close the query, saving if necessary.

$11.$ Open the TopValuesProperty query in Design View. Modify the query to sort the PropertyDamage amounts in descending order. Change the Return value to display only the top $5$ records. Open the query in Datasheet view, then close the query, saving if necessary.

$12.$ Open the TotalCoverage query in Design View. Modify the query by creating a calculated field. Enter TotalCoverage: $[$Liability$]+[$PropertyDamage$]$ in the Zoom dialog box of the first empty column in the design grid. Save the query. Open the query in Datasheet View, then close the query, saving if necessary.