Create a report listing all customers grouped by Sales Rep (include Sales Rep ID and full name with Customer ID, full name and State.)Create two forms (user interface), to update and modify information for both tables. For extra credit a menu using the “switchboard” component of Access that allows you to access the update forms and view reports.

MS Access
it\’s a microsoft access assignment
the work has to be done on microsoft access (there are steps written in too in the attachment)Create a relational database for your company.Note: Business Account field should be in a checked/unchecked format (logic field).Create a minimum of 25 customer records, with at least 5 living in Massachusetts. The customer Credit Limit should range from $500-$5000. Current Balance should not exceed the credit limit.There are a total of 4 sales representatives within the company; each sales rep should be assigned an approximate equal number of customers.Create a query and report to find all customers not living in Massachusetts; create a query and report listing all customer names and states, grouped by State.Create a query to calculate Credit Available (you will need to create a new field within the query to do this), and then create a report that lists Customers in order of descending available credit.Create a report listing all customers grouped by Sales Rep (include Sales Rep ID and full name with Customer ID, full name and State.)Create two forms (user interface), to update and modify information for both tables. For extra credit a menu using the “switchboard” component of Access that allows you to access the update forms and view reports. (Extra credit now, a requirement for the course project!)Turn in your work on a flash drive: Your forms (2), tables (2), queries (3), and reports (4).