Rose Lawn Care 1. Description 1). Customers table. Rose's existing customers and their account balances at the beginning of October are: Customer No. CustomerName Address AccountBalance Service Repa C40 Your Name 123 Riverpoint $200 $10 C20 Lars Anders 205 Natten $45 503 C33 Cleaners Atari 147 Main $80 $20 C50 Eric Jones 358 Pine $40 503 C60 Dan Martinez 410 Orange $0 503 C12 Dave Jensen 220 Division $20 $10 C70 Ted Smith 666 Martin $30 $20 C80 Rex Davis 211 Martin $50 503 2). Service Representatives table. Rose's part-time service representatives ServiceBepa S03 $10 $20 Service RepName Service ReplayBate Brian $15.00 $17.25 $20 Alex Fred 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. Choose the proper field data types a. Create two tables for the data, set a primary key for each table. The validation rule for SatxisRenBats is less than 30. (20 points) b. Input the data. (5 points) c. Create relationship and Specify referential integrity between the two tables. (10 points) d. Create a query named Query-d to display customers (CustomerNams. Account Balance) that have an account balance great than $40. (7 points) e. Create a query named Query-e to find the lowest service representative pay rate (note: only one value). (7 points) Create a query named Query-f to display (CustomerNa CustomerNams. Address, AccountBalance Serviss RenName SatxissBeaPaxBats). (7 points) g. Create a query named Query-g to list CustomerNams. AccountBalanss. Serviss RepName for the customers who have a balance greater than $40. (7 points) h. Create a query named Query-h to add a calculated field that displays a new service representative pay rate that is 110% of the ServiceRepPaxBate. Use NewPayRate for the new field. (7 points) i. Create a query named Query-į to find the average account balance group by service representative names. (10 points) j. Create a form for customers. (5 points) k. Create a stepped formatted report to show service representatives and the related customers. (10 points) 1. Change database properties to include your name. (5 points) Please use your last name as your Access file name, save the file, and then submit the file to the Canvas.