In Microsoft ACCESS 7. Create a table for the Branch Managers titled BranchMngrTbl. Add the following fields: Field Name Data Type MngrID AutoNumber MngrName Text MngrPhone Text MngrPay Currency MngrStore Number a. Set MngrID as your primary key and add a description that states this is the primary key. b. Set the default value of a Branch Managers pay to $5,000. c. Add a validation rule so that Branch Managers pay cannot exceed $50,000. i. Hint: Would you ever receive negative pay? d. Create a relationship between the BranchMngrTbl and StoreTbl. i. Remember to check Enforce Referential Integrity. 8. Populate the BranchMngrTbl with the following: MngrName MngrPhone MngrPay MngrStore Your TAs Name 513 555 9400 $10,000 4 Your Professors Name 513 555 9401 $15,000 3 Your Name 513 555 9402 $20,000 2 Your Favorite Cartoon Characters Name 513 555 9403 $25,000 1 9. Create a report based on the ProductTbl and CustomerTbl with the following fields: Product Category Product Description Customer Name a. Group the data by Customer Name. (Organize the data b CustomerTbl. No more group levels are needed.) b. Sort Product Category in Ascending order. Use a stepped layout, portrait orientation. c. Save the report as CustomerOrderRpt. d. Adjust the column widths so all values are visible. e. Rename the field titles and header with more descriptive terms.