Create action queries for Coast Jewelers (after backing up your file)
a. Create and run an action query for Coast Jewelers that increases the sales markup 5 percent for all categories. Save this query as Ch 11 Assignment 7a. Print the resulting category table.
b. Create a parameter query for Coast Jewelers 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 price. Save this query as Ch 11 Assignment 7b. Run and print the query entering Casio USA as the supplier.
c. Create and run a delete query for Coast Jewelers that deletes all products where Supplier ID = 1. 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, in ascending order by supplier ID. Save this query as Ch 11 Assignment 7c 1