Product ID

Product ID	Production Description	Price	Stock on Hand	Shipping Charge
100	Wonder Diet	$11.92	560
101	Nail Trimmer	$11.03	205
102	Wonder Diet-Cats	$6.26	256
103	Flea Shampoo	$5.62	658
104	Clippers - Hair	$25.37	56
105	Silky Shampoo	$7.86	632
106	Lunation for Coats	$17.56	248
107	Dog Vitamins	$15.63	77
108	Nail Trimmer - Large	$17.66	963
109	Rawhide Bone - Small	$3.90	145
110	Bird Bell	$15.24	65
111	Bird Shampoo	$12.00	122
112	Tapir Bin	$24.50	2
113	Shampoo for Oxen	$20.00	14
114	Bird Fodder	$4.00	28
115	Binoculars	$80.00	40
116	Coat Brush	$ 14.00	20
117	Shampoo for Elephants	$200.00	2
118	Elephant Tick Remover	$ 80.00	4
119	Catnip	$ 1.50	10
120	Lion King Halloween Costume	$ 12.00	20

· Call the above table “Supplies” and place it in a database called “Looney Tunes Pet Supplies”

· Create an update query that finds the records in the “Supplies” table containing shampoo items; update the shipping charge in these items to $4.00. Print the results.

· Create a parameter query for the “Supplies” table for the “Product ID” field.; save the query as QRY-Product ID

· Customers will often call a store and ask for which items the store stocks that have a certain price. Create a parameter query for the “Supplies” table for the “Price” field; save the query as QRY - Price

· Create a query containing all fields above; include an expression that calculates Cost based on the formula: Price + Price*.08 + Shipping Charge

· Print the above table and “cost” query

Product ID

Price

Stock on Hand

Shipping Charge