Please answer the questions that are highlighted with steps on Microsoft Access

B20 B30 B60 B70 B80 MISC311 Spring 2021 MAKEUP/RETAKE Access Exam: Carl's Construction 1. Description 1). Customers table. Carl's existing customers and their account balances at the beginning of June are: Customer No Customer Name Address AccountBalance ServiceRep.No B40 Your Own Name 123 Fifth $200.50 SR10 Sam Nichols 205 Morton $45. SR30 Tom Hart 147 First S80.90 SR20 B50 Carl Mint 358 Oak $40.90 SR30 Adam Smith 410 Orange SO SR30 B10 Rick Jones 220 Division $20.05 SR10 Brian White 666 Martin $30.15 SR20 Bob Thomas 211 Martin $50 SR30 2). Service Representatives table. Rose's part-time service representatives ServiceRepNo ServiceRepName ServiceRepPay Rate SR30 Cooper $14. SR10 Murphy $17.25 SR20 Morton $22. 2. Database Application Requirement: Using Access to (Total 100 points) Please use your last name as your Access file name, save the file, and then submit the file to the Canvas. SAVE the file before you begin the following steps. Choose the proper field data types. a. Create two tables for the data, set a primary key for each table. (15 points) b. The validation rule for ServiceRepRate is less than or equal to $20.00. (5 points) c. Input the data properly. (5 points) d. Create relationship and Specify referential integrity between the two tables. (15 points) e. Create a query named Query-e to display customers CustomerName, AccountBalance, and ServiceRepName) that have an account balance less than $50. (5 points) f Create a query named Query-f to find the highest service representative pay rate (note: only one value). (5 points) g. Create a query named Query-g to display CustomerNo. CustomerName, Address, AccountBalance, ServiceRepName, ServiceRepPayRate). (5 points) h. Create a query named Query-h to list CustomerName, AccountBalance ServiceRepName for the customers who have a balance greater than $75 and less than $500. (5 points) i. Create a query named Query-i to add a calculated field that displays a new service representative pay rate that is 103% of the ServiceRepPayRate. Use UpdatedPayRate for the new field. (10 points) j. Create a query named Query-j to find the average account balance group by Service Representative Number (ServiceRepNo) (5 points) k. Create a parameter query named Query k to display CustomerNo, CustomerName, and ServiceRep No entering Morton for the service rep name. (5 points) 1. Create a form for customers. (10 points) m. Create a stepped formatted report to show Service Representatives Number and Name and their related Customers' Name. (10 points) B20 B30 B60 B70 B80 MISC311 Spring 2021 MAKEUP/RETAKE Access Exam: Carl's Construction 1. Description 1). Customers table. Carl's existing customers and their account balances at the beginning of June are: Customer No Customer Name Address AccountBalance ServiceRep.No B40 Your Own Name 123 Fifth $200.50 SR10 Sam Nichols 205 Morton $45. SR30 Tom Hart 147 First S80.90 SR20 B50 Carl Mint 358 Oak $40.90 SR30 Adam Smith 410 Orange SO SR30 B10 Rick Jones 220 Division $20.05 SR10 Brian White 666 Martin $30.15 SR20 Bob Thomas 211 Martin $50 SR30 2). Service Representatives table. Rose's part-time service representatives ServiceRepNo ServiceRepName ServiceRepPay Rate SR30 Cooper $14. SR10 Murphy $17.25 SR20 Morton $22. 2. Database Application Requirement: Using Access to (Total 100 points) Please use your last name as your Access file name, save the file, and then submit the file to the Canvas. SAVE the file before you begin the following steps. Choose the proper field data types. a. Create two tables for the data, set a primary key for each table. (15 points) b. The validation rule for ServiceRepRate is less than or equal to $20.00. (5 points) c. Input the data properly. (5 points) d. Create relationship and Specify referential integrity between the two tables. (15 points) e. Create a query named Query-e to display customers CustomerName, AccountBalance, and ServiceRepName) that have an account balance less than $50. (5 points) f Create a query named Query-f to find the highest service representative pay rate (note: only one value). (5 points) g. Create a query named Query-g to display CustomerNo. CustomerName, Address, AccountBalance, ServiceRepName, ServiceRepPayRate). (5 points) h. Create a query named Query-h to list CustomerName, AccountBalance ServiceRepName for the customers who have a balance greater than $75 and less than $500. (5 points) i. Create a query named Query-i to add a calculated field that displays a new service representative pay rate that is 103% of the ServiceRepPayRate. Use UpdatedPayRate for the new field. (10 points) j. Create a query named Query-j to find the average account balance group by Service Representative Number (ServiceRepNo) (5 points) k. Create a parameter query named Query k to display CustomerNo, CustomerName, and ServiceRep No entering Morton for the service rep name. (5 points) 1. Create a form for customers. (10 points) m. Create a stepped formatted report to show Service Representatives Number and Name and their related Customers' Name. (10 points)