Create action queries for What SUP. (Use the Ch11-02 student file, or use the file you used in answering the previous question.)

a. Create and run an update query that increases the unit price for all products by 6 percent. Save this query as Ch 11 Assignment 7a. Create and print an additional query listing the product name and unit price after running the update query. Do not save this query.
b. Create a parameter query that lists products purchased from a particular supplier. The query should ask ‘‘Enter supplier’s name:’’ and list the supplier name, product name, quantity, and unit cost. Save this query as Ch 11 Assignment 7b. Run and print the query entering Bark as the supplier.
c. Create and run a delete query that deletes all products where Quantity¼0. Save this query as Ch 11 Assignment 7c. Create and print a query listing the supplier ID and product name for all products still in the database.