Now that you have created the query, you will create a second query for Adam 10 that will calculate the number of credits students lost upon transfer, the tuition payments for which they will be responsible (assuming three payments per semester), and the due date of the first payment. Create a copy of the Transfer Credits query. Name the copy Transfer Calculations. Open the new query in Design view. Remove the criteria from the AdmissionDate field. Create a calculated field in the first empty field cell of the query named LostCredits that subtracts CreditsTransferred from CreditsEarned. Create another calculated field named TuitionPayments that uses the payment function and determines tuition paid in four installments. The student's tuition payment and a 2.5% interest rate should be used in the function. Use 0 for the future_value and type arguments. Ensure that the payment appears as a positive number. Format the TuitionPayments calculated field as Currency. Create another calculated field named FirstPayment after the TuitionPayments field. To calculate the due date, add 30 to their AdmissionDate. Run the query and verify that the three calculated fields have valid data. Add a total row to the datasheet. Sum the TuitionDue column and average the TuitionPayment column. Save and close the Juanb