Create Access Queries to complete the following:

A. Find businesses and their orders sorted by Salesman Last Name. Include the following attributes: Business Number, Business Name, Order Number, Billing Date, Salesman Last Name, and Commission Amount (derived attribute based upon Invoice Amount and Commission Rate).

B. For all salesmen with current customers, create a list of each business (one record per business) with unpaid orders. Include the following attributes: Salesman Number, Salesman Full Name (derived from Salesman Last Name and Salesman First Name), Business Number, Business Name, and Owner Name.

C. Show Owners with unpaid bills (an order is classified as unpaid if the Paid indicator is = No), listing the Owner Name, Owner Phone, Business Number, Business Name, the amount Due, and a new amount Due (original amount Due with a 7% finance charge added), Sorted by New amount Due in descending order. d. Create a parameter based query to accept a region code and display the State, Salesman Number, Salesman Full Name, and all businesses in that region.

- - OwnerTitle - Ms. BusinessInfo BusinessNur 750 779 783 788 798 BusinessName Grain Bin Inn Gateway Lounge First Edition Restaurant The Empire Embers Restaurant BusinessPhc - Street - City - (401) 339-1200 5013 North Cliff Avenue Woonsocket (401) 361-1000 3408 Gateway Boulevard Cranston (860) 461-8899 3509 Garfield Avenue Norwich (860) 762-9100 10 Sycamore Street Norwich (603) 816-2400 4004 West 41st Street Nashua State RI RI ZipCode 02895 02920 06365 06365 03060 Ms. Mr. Ms. OwnerFName Bridgit Susan Shannon Curtis Clifford OnwerLNam - OwnerPhon- Feeney (401) 339-1264 Mouw (401) 361-1137 Petree (860) 461-2932 Haiar (860) 762-9144 Merritt (603) 816-2456 NH Mr. Paid OrderNum - BusinessNur- 200 135 104 202 203 204 205 206 207 208 InvoiceAmt - BillingDate - 871.35 01/27/2017 1,280.50 01/27/2017 1,190.00 01/27/2017 1,055.00 01/27/2017 654.50 01/27/2017 1,392.50 01/27/2017 1,604.50 01/27/2017 1,784.00 01/27/2017 State - RI SalesNum 100 110 200 300 - SalesFName - SalesLName - CommRate - SalesRegion - James King 0.25 1 Arthur Dolan 0.30 1 Samantha Rose 0.30 2 John Miller 0.35 3 VT