GO19_AC_CH02_GRADER_2E_HW – Biology Supplies 1.1

Copy   the 2E Items by Room Query to create a new query with the name 2E Item Categories Query. Redesign the query to answer the   question: What is the item ID, item   name, category, vendor ID, and quantity in stock for all items, sorted in   ascending order by the Category field and the Vendor ID field? Display   only the fields necessary to answer the question and in the order listed in   the question. Be sure that the fields are sorted in the correct order in   Design view, so that the results display the categories in ascending order,   then the Vendor IDs within each category in ascending order. Close the query,   saving the design changes.