Create a query in Design view using the Capt Inventory table that prompts you to enter the Supplier ID$,$ and then answers the question What is the supplier id$,$ sport, category, item name, and cost for inventory items, sorted in ascending order by the item name? Add the fields in that order. The query should prompt an individual to Enter the Supplier ID$.$ Run the query, and type SUPP$-04$ when prompted for the criteria. Two records match the criteria.Save the query as Cap Parameter Query and close it$.$