Computer Information Systems Proposal
Proposal: Implementation of Microsoft Access Database
BIS 220
[pic]
Party Plates and Napkins Company
Table of Contents
Introduction 3
Benefits of Implementing Microsoft Access 3
Sales and Collaborative Software 4
Table……………………………………………………………………………………………....5
Conclusion 5
References...………………………………………………………………………………….……6
Proposal: Implementation of Microsoft Access Database
Introduction
Our party plates manufacturing business is growing and our customer base numbers are increasing every month therefore I am writing this proposal to implement a “Relational Database Management system”. The system we are proposing is Microsoft Access. The reason we are proposing to implement this new system is because since our business is growing it is getting cumbersome and time consuming to manage multiple “Excel” files to analyze company’s data. According to article by CPA Janet Samuels and Robert wood they suggest “Data handling and reporting capabilities of access are more efficient” (Samuels, Woods 2007). Excel should be used when we need to create a onetime report by plugging in data, however in access you will have to setup a database to form reports. Therefore, we should implement the relational database so information is forever stored and accessible by employees to create different multiple reports. The benefits of implementing Microsoft Access over Excel are listed below.
Benefits of Implementing Microsoft Access
1. We can easily import all of our Excel files in to access by using the External data ribbon. This imported data will be saved as one of the tables in the database file. This is one of the major reason we are implementing “Access” because all of our current data will easily be imported in to Access. 2. Microsoft Access allows expanded flexibility regarding users who will not need extra training to edit data in Access, The software provides basic templates to get started or a user can go through a help wizard to start a
BIS 220
[pic]
Party Plates and Napkins Company
Table of Contents
Introduction 3
Benefits of Implementing Microsoft Access 3
Sales and Collaborative Software 4
Table……………………………………………………………………………………………....5
Conclusion 5
References...………………………………………………………………………………….……6
Proposal: Implementation of Microsoft Access Database
Introduction
Our party plates manufacturing business is growing and our customer base numbers are increasing every month therefore I am writing this proposal to implement a “Relational Database Management system”. The system we are proposing is Microsoft Access. The reason we are proposing to implement this new system is because since our business is growing it is getting cumbersome and time consuming to manage multiple “Excel” files to analyze company’s data. According to article by CPA Janet Samuels and Robert wood they suggest “Data handling and reporting capabilities of access are more efficient” (Samuels, Woods 2007). Excel should be used when we need to create a onetime report by plugging in data, however in access you will have to setup a database to form reports. Therefore, we should implement the relational database so information is forever stored and accessible by employees to create different multiple reports. The benefits of implementing Microsoft Access over Excel are listed below.
Benefits of Implementing Microsoft Access
1. We can easily import all of our Excel files in to access by using the External data ribbon. This imported data will be saved as one of the tables in the database file. This is one of the major reason we are implementing “Access” because all of our current data will easily be imported in to Access. 2. Microsoft Access allows expanded flexibility regarding users who will not need extra training to edit data in Access, The software provides basic templates to get started or a user can go through a help wizard to start a
References: What is Collaborative Software. (2011). Retrieved from http://www.wisegeek.com/what-is-collaborative-software.htm Samuels, J. A., & Wood, R. E. (2007). Want More Effective and Efficient Data Analysis? Use Access!. Strategic Finance, 89(4), 47-51.