After you have worked through Perry Chapter $4,$ download the Access #$2$ Homework file from the Assignments link on the $475$ Blackboard site, do the homework problems listed below and save the objects as indicated in each problem. Rename the file YourLastName. Access$2.$aced and sulkat it under the Access Homework $2$ assignment link on Blackboard.

NOTE: DO NOT WRITE SQL STATEMENTS FOR THESE PROBLEMS, USE QBE.

Problem $1$: Management has discovered input errors in tblInvoice. Due to rising shipping prices the company had stopped using FedEx as a shipper after December $31,$

$2011.$ For all shipments in $2012,$ the company used USPS in place of FedEx. However, for some $2012$ shipments the data entry person simply assumed FedEx was still being used and recorded FedEx as the shipper. Create a copy of tblInvoice and paste it back as tbIProblem$1.$ Then create an update query that corrects the problem described in tblProblem$1,$ run the query once to check that it works, and then save the query as qupdProblem$1.$

Problem $2$: Create a parameter query to obtain a list the InventoryID, Item Name, and UnitsOnHand fields for specific categories of inventory items. Before running, the parameter query should ask the user to indicate whether the items they are looking for

Present