Question

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.

Answer 1

In the query "Transfer Calculations," remove criteria from AdmissionDate, create a calculated field "LostCredits" to find the difference between CreditsEarned and CreditsTransferred, and another "TuitionPayments" using a payment function with 2.5% interest to determine tuition paid in four installments as a positive number.

Step-by-step explanation:

You've been asked to modify a query in a database application, likely within Microsoft Access or a similar program. The instructions are to create a copy of an existing query, which should be renamed to "Transfer Calculations". Upon opening the new query in design view, you are to remove any criteria from the AdmissionDate field.

The next step is to create a calculated field called LostCredits which will compute the difference between CreditsEarned and CreditsTransferred. The expression for this calculation would look something like "LostCredits: [CreditsEarned] - [CreditsTransferred]".

Then, you'll need to create another calculated field named TuitionPayments, using a payment function to calculate the tuition paid over four installments, with a 2.5% interest rate. To ensure the payment value is positive, you would alter the payment function accordingly. The expression might look like "TuitionPayments: Abs(Pmt(0.025/4, 4, -[Tuition], 0, 0))", where Abs ensures the number is absolute (positive) and Pmt is the payment function.