Create a query in Design view, using your Cap1 Inventory table to answer the question.

What is the item name (in alphabetical order), retail price, and category for the sport of hiking? Add the fields in that order. Do not display the Sports field in the query results. Run the query, save it as Cap1 Hiking Query, then close the query. Seven records match the criteria.

Answer rating: 100% (QA)

Solution 1 Firstly we have to click on query design option in create menu 2 we can write query using ... View the full answer