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.
