9 Copy the Supplies Sort Query to create a new query
20 with the name Kits Query . Redesign the query so that the following fields display in the order given : Item Name , Category , Price Per Item , Quantity in Stock , and Vendor ID . Sort the records in ascending order only by the Item Name field . Set the criteria so that when you run the query only those records display that have kits as the Category . Do not display the Category field in the query results . Run the query ( six records display ). Close the query , saving the changes to the query .
10 Create a query in Query Design view based on the
13
Vendors table . Add the following fields to the design grid in the order given : Vendor ID , Vendor Name , and Phone . Sort the records in ascending order by the Vendor Name field . Set the criteria so that when you run the query only those records display that are missing a phone number . Run the query ( two records display ). Save the query as Missing Phone Query , and then close the query .