Product ID

Product ID	Production Description	Customer First Name	Customer Last Name
100	Wonder Diet	Steve	Wonesky
101	Nail Trimmer	Mike	Smith
102	Wonder Diet-Cats	Alfred	Warren
103	Flea Shampoo	Jane	Doe
104	Clippers - Hair	Alfred	Neuman
105	Silky Shampoo	Brian	Schif
106	Lunation for Coats	Chanel	Goldman
107	Dog Vitamins	Kevin	Gonzalez
108	Nail Trimmer - Large	Jose	Smurf
109	Rawhide Bone - Small	Ed	Begley
110	Bird Bell	Tom	Thumb

· Call the above table “Supplies” and place it in a database called “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 query that contains all the fields above, but that also concatenates the first and last name fields. Save the query as “Customer Info”, and print.

Product ID

Customer First Name

Customer Last Name