LUILIJICILELI IIEILI d2- LUIIEIILF. CHILI EILILI I1 LCIIJIJUFI UI L'Ih'LU-UIIL HIIIL. L-llllgt' Llll: IULI rowto Sum. Run the query. Save the query as Drder Summary. Return to Design Add criteria to the CIrderDate eld so only orders made between Ll'lfll and 1213112016 are displayed. Change the Total rowto 'iI'II'here. This expression will display only orders that were created in 2t] 16. Run the query and 1Irie wthe resulls. Save and close the query. Hint: To add the criteria, click in the Criteria row and type Between # lflll lti# And # 12I31I'2l] 16#. Create a copy of the Drder Summary query named Clrder Financing. Switch to Design IIriewofthe newquery and remove the Discountrnount eld. . a a a new 'e 1 using t - Expression Bui ner name Samp ePayment. Insert t -- Prrrt Jnction with the follo wing parameters: - Use 115112 for the rate argument {5% interest, paid monthly] - Use the number 12 for the num riods argument [12 months] - Use the calculated eld [Exten edAmount] for the present_1.ra|ue Hint: Dn the Design tab' in the Query Setup grou pr Cliclc the Builder: Locate and double-click the Pmt function. Enter the arguments as Change the Total row to Expression for the SamplePayment eld. Change the Format for the SampleP'ayment eld to Currency. Run the query and verify the second order has a sample payment of $125.34. Note: it will display as a negative number. Save and close the query. Create a copy of the lDrder Summary query nar'r'Ied rder Summary by Country. Replace the IiIIIrderlD eld with the Country eld in Design yie w ofthe new query. Run the query and then examine the summary records; there should be 5 countries listed. Switch to Design 1.Iie'IIir and change the sort order so that the country wi'I the highest ExtendedAn'Io-unt is rst and the country with the lowest ExtendedAmount is last. Run the query and verify the resulls. Save and close the query. Hint: Sort Descendin i Close all database objects Close the database and then exit Access. Submit the database as directed