Can you please help me with this confusing assignment step by step please? Client Request Worksheet You are a business owner in need of someone to design a database that will make it easier for you to manage your customer and/or sales information. Complete this worksheet to provide a potential database developer with the information he or she would need to build a database that meets your companys needs. Note: Be specific and thorough in your responses. Business Overview Owners Name (thats you): Click to enter text (1 point) Company Name: Click to enter text (1 point) Provide a brief overview of the company (products/services provided, customer base, goals, etc.) (2 points) Click to enter text Database Needs Briefly describe the need for a well-designed, user-friendly database. How will this database help your company? Click to enter text (3 points) Identify three custom reports and/or queries that you need to be able to run from the database. Be specific (i.e. Generate a report of customers who have a balance of $100 or more.). Custom Report/Query #1 (2 points) Custom Report/Query #2 (2 points) Custom Report/Query #3 (2 points) Customer Data In order to build a functioning database, the database developer will need access to your customer data (names, addresses, contact information, etc.). First, download the Sample Customer Data spreadsheet (.csv). This spreadsheet is pre-populated with 50 fictional customers, their addresses, emails, and phone numbers. Once you have downloaded the spreadsheet, you will need to customize the data to fit your company and make it possible to run the custom reports and queries you requested above. For example, you may need to add a column that includes each customers current balance, total purchases, date of membership, or any other information that you would collect about your customers in order to run your company efficiently. Add and populate at least three columns to the existing customer data spreadsheet, making sure that you have provided all of the necessary data to run the reports and queries youve requested possible. Save the Customer Data spreadsheet (.csv), along with this worksheet. You will submit both files to the Assignment area of Blackboard. (12 points)

part 2 of the assignment is below

CIS 225 Project Guidelines Based on your Client Request Worksheet, create an Access database that follows the guidelines listed for each of the following areas. Database Table Design Create your database tables using the methods that were discussed over the course of this semester. Remember, Access is a Relational Database Managements System, make sure to create valid relationships between tables, each containing the necessary primary and foreign keys. Design your database to the Third Normal Form. Consider all the field properties while designing your database tables. Data Entry Create all the necessary forms and sub-forms to allow a user to enter new customer and/or product information. Be sure to implement all the necessary data validation features to reduce errors and ensure high quality data is being entered into the database. Be sure to design forms that are appealing to the eye and not the default form layout provided in Access. Custom Queries and Reports Your Client Request outlines three custom reports and queries that are necessary for the company to operate efficiently. When creating these reports, do not use the default report designs. Customize them and make them look appealing to the user. Switchboard Once you have created your database and are able to enter all the necessary data and run reports and queries, create a switchboard to make it easy for any user to quickly navigate to necessary functions and reports.