Room , Location , and Quantity in Stock . Sort the records in ascending order by the Room field and the Location field . Run the query , save it asItems by Room Query , and then close the query .
7 Copy the Items by Room Query to create a new query
16 with the name Item Categories Query . Redesign the query so that the following fields display in the order given : Item ID , Item Name , Category , Vendor ID , and Quantity in Stock . Sort the records in ascending order first by the Category field and then by the Vendor ID field . Run the query , and then close the query , saving the changes to the query .
8 Copy the Items by Room Query to create a new query
16 with the name Supplies Sort Query . Redesign the query so that the following fields display in the order given : Item Name , Category , Price Per Item , and Quantity in Stock . Sort the records in ascending order by the Category field and in descending order by the Price Per Item field . Run the query , and then close the query , saving the changes to the query .