Points Step Instructions Possible 11 Create a copy of the Revenue and Cost by Country query named Customer Payments. Switch to Design view of the new query and remove the Country, TotalCost, and OrderDate fields. Add the FirstName and LastName fields, Move the TotalRevenue field to the end. Rename the TotalRevenue field to OrderTotal. Change the caption to Order Total. 12 Add a new field using the Expression Bullder named SamplePayment. Insert the Pmt 10 function with the following parameters: - Use .05/12 for the rate argument ( 5% interest, paid monthly) - Use the number 12 for the num periods argument (12 months) - Use the calculated field OrderTotal for the present_value - Use 0 for both future_value and type 13 Change the Total row to Exression for the SamplePayment field. Change the Format for the SamplePayment field to Currency. Run the query and verify the second order(with LastName Sparks) has a sample payment of $26.80. Note: it will display as a negative number. Save and close the query. 14 Create a copy of the Revenue and Cost by Country query named Revenue by Sales Rep. 5 Switch to Design view of the new query and remove the entire Customers table, the TotalCost, and OrderDate fields. Add the Sales Reps table. Add the Title field from the Sales Reps table and move it to the front of the TotalRevenue field. 15 Run the query and then ecamine the summary records; there should be 4 Titles listed. Switch to Design view and change the sort order so that the title with the highest TotalRevenue is first and the tite with the lowest TotalRevenue is last. Run the query and verify the results. Save and close the query. 16 Close all database objects. Cose the database and then exit Access. Submit the database as directed. 0 Total Points 100 Points Step Instructions Possible 11 Create a copy of the Revenue and Cost by Country query named Customer Payments. Switch to Design view of the new query and remove the Country, TotalCost, and OrderDate fields. Add the FirstName and LastName fields, Move the TotalRevenue field to the end. Rename the TotalRevenue field to OrderTotal. Change the caption to Order Total. 12 Add a new field using the Expression Bullder named SamplePayment. Insert the Pmt 10 function with the following parameters: - Use .05/12 for the rate argument ( 5% interest, paid monthly) - Use the number 12 for the num periods argument (12 months) - Use the calculated field OrderTotal for the present_value - Use 0 for both future_value and type 13 Change the Total row to Exression for the SamplePayment field. Change the Format for the SamplePayment field to Currency. Run the query and verify the second order(with LastName Sparks) has a sample payment of $26.80. Note: it will display as a negative number. Save and close the query. 14 Create a copy of the Revenue and Cost by Country query named Revenue by Sales Rep. 5 Switch to Design view of the new query and remove the entire Customers table, the TotalCost, and OrderDate fields. Add the Sales Reps table. Add the Title field from the Sales Reps table and move it to the front of the TotalRevenue field. 15 Run the query and then ecamine the summary records; there should be 4 Titles listed. Switch to Design view and change the sort order so that the title with the highest TotalRevenue is first and the tite with the lowest TotalRevenue is last. Run the query and verify the results. Save and close the query. 16 Close all database objects. Cose the database and then exit Access. Submit the database as directed. 0 Total Points 100
