Describe a Business Information System, MS Access Individual Project.
1. Import or create the Insurance Plan table from the excel file. You may import this into Access or manually create the table. Be sure to set the index and primary key. (20 points)
2. Create an employee report showing First Name, Last Name, Title, City (Location), State, Plan Name, and the Cost to the Employer. Name this query “Employee Report”. (30 points)
3. Create a second query and filter this for one state of your choosing. Make sure the state field is not in the query output. Perform this filter in the query designer and not using the filter feature on the query output. Name this query “XX Employers” where XX is the abbreviation for the state you chose. (30 points)
4. Create a query that shows the aggregate Cost to Employer by state and plan. The output should have the fields in this order: State, PlanName, CostToEmployer. Name this query “Insurance Cost to Employer”. (20 points)
Solved by verified expertAn MS Access individual project is a database management system developed by Microsoft. It is widely used in small to medium-sized businesses to manage their data. An MS Access individual project is a custom-built database that is designed to meet the specific needs of a business.
The goal of a BIS built using MS Access is to help the business capture, organize, and analyze data to support decision-making. The BIS can be used to manage various functions such as inventory, sales, customer service, and marketing. The system can be customize
Looking for a similar assignment?
Let Us write for you! We offer custom paper writing services
The following are some of the key features of an MS Access individual project:
Data Entry Forms: The system will have forms for data entry that will allow users to input data into the system. The forms will be designed to capture all the necessary data required by the business.
Data Validation: The system will have validation rules that ensure that data entered into the system is accurate and complete.
Queries: The system will have queries that will allow users to extract data from the database. The queries will be designed to provide the user with the necessary information required to make informed decisions.
Reports: The system will have reports that will present data in a meaningful way. The reports will be designed to meet the specific needs of the business.
Security: The system will have security features that will ensure that only authorized users have access to the system. The system will have user-level security that will allow the administrator to control access to the system.
Backup and Recovery: The system will have backup and recovery procedures in place to ensure that data is not lost in the event of a system failure.
In summary, an MS Access individual project is a custom-built BIS that is designed to meet the specific needs of a business. The system will have features such as data entry forms, data validation, queries, reports, security, and backup and recovery procedures to ensure that data is captured, organized, and analyzed to support decision-making.
