Problem
Create a query in Design view using the Capl Inventory table that prompts you to enter the Sport, and then answers the question: What is the sport, category, item name, and retail price for inventory items, sorted first in ascending order by category and then in ascending order by the item name? Add the fields in that order. The query should prompt an individual to Enter the Sport. Run the query, and type hiking when prompted for the criteria. Seven records match the criteria. Save the query as Capl Parameter Query and close it.