Open the Missing Addresses query in Design view. Add a new column to determine if a customer does not have an address on file. If the customer’s Address is null, it should display Missing. If not, it should display nothing. Name the column AddressPresent. Add criteria of Missing to the column you just created, so only the customers missing an address display. Move the AddressPresent field so it appears between PhoneNumber and Address. Run the query. Ensure only customers with null Address fields display. Save and close the query.

Open the Loans By Interest Rate query in Design view. Create a new column to round the InterestRate of each Loan to the nearest whole number. Name the field RoundedRate. Save and close the query.

Open the Payment By Month query in Design view. Change the first column so that instead of grouping by the payment date, you group by the month. Use the DatePart function to extract the month from the date. Name the column MonthNumber. Group by the MonthNumber field, and display the Sum of the first Total field and the Average of the Average field. Run the query. The first line should read 2 (as the month, representing February), with a total of $5,396.51 as the total payments received and $1,349.13 as the average payment amount. Save and close the query.

Open the Refinance Candidates query in Design view. This query displays all adjustable loans in the database. Create a new column to display High Priority for all loans that have an InterestRate of 7.5% or more, and Low Priority otherwise. Name the field Priority. Run the query. Notice customers with the highest interest rate values show a higher priority. Save and close the query.