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.