Rose Lawn Care 1. Description 1). Customers table. Rose's existing customers and their account balances at the beginning of October are: Customer Serxis Rep.SA S10 C40 C20 503 520 Customer Your Name Lars And Cleaners Atari Eric Jones Dan Martinez Dave Jensen Ted Smith Rex Davis Address Account Balance 123 Riverpoint S200 205 Sorta $45 147 Main 358 Pine 410 Orange SO 220 Division $20 666 Martin 530 211 Martin C33 CSO C60 C12 C70 S80 $40 SO3 SO3 510 S20 S03 CRO $50 2). Service Representatives table. Rose's part time service representatives Serxis Repe SO3 SIO Serxies Repam Brian Alex Serxitekeplay Bate SI5.00 $17.25 $20 Fred 520 2. Database Application Requirement: Using Access to (Total 100 points) Please we your last name as your Access file name, save the file, and then submit the file to the Canvas Choose the proper lle data types Create two tables for the data, seta primary key for each table. The validation rule for Service Replate 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 Queryd to display customers Customer Nams, 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) 1. Create a query named Query-f to display Customer e SustentNams. Address, AssouadBalanse Ssexiss Replace SexissRsa RexBats). 7 points) 5. Create a query named Query to list Suestes Sacs Assos Balancs. Ssexis Rename for the customers who have a balance greater than $40. (7 points) Create a query named Query I to add a calculated field that displays a new service representative pay rate that is 110% of the SardicsRepRax Bats. Use Sea Ray Rate 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 Rose Lawn Care 1. Description 1). Customers table. Rose's existing customers and their account balances at the beginning of October are: Customer Serxis Rep.SA S10 C40 C20 503 520 Customer Your Name Lars And Cleaners Atari Eric Jones Dan Martinez Dave Jensen Ted Smith Rex Davis Address Account Balance 123 Riverpoint S200 205 Sorta $45 147 Main 358 Pine 410 Orange SO 220 Division $20 666 Martin 530 211 Martin C33 CSO C60 C12 C70 S80 $40 SO3 SO3 510 S20 S03 CRO $50 2). Service Representatives table. Rose's part time service representatives Serxis Repe SO3 SIO Serxies Repam Brian Alex Serxitekeplay Bate SI5.00 $17.25 $20 Fred 520 2. Database Application Requirement: Using Access to (Total 100 points) Please we your last name as your Access file name, save the file, and then submit the file to the Canvas Choose the proper lle data types Create two tables for the data, seta primary key for each table. The validation rule for Service Replate 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 Queryd to display customers Customer Nams, 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) 1. Create a query named Query-f to display Customer e SustentNams. Address, AssouadBalanse Ssexiss Replace SexissRsa RexBats). 7 points) 5. Create a query named Query to list Suestes Sacs Assos Balancs. Ssexis Rename for the customers who have a balance greater than $40. (7 points) Create a query named Query I to add a calculated field that displays a new service representative pay rate that is 110% of the SardicsRepRax Bats. Use Sea Ray Rate 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