Efficiency & Collaboration Proposal
Efficiency and Collaboration Proposal Norris Johnson
BIS/220
July 23, 2012
Efficiency and Collaboration Proposal
Mr. Bob Jenkins
Party Plates, Inc.
8462 Anywhere Lane
Smalltown, AZ. 00000
July 23, 2012
Subject: Efficiency and Collaboration Proposal
INTRODUCTION
The purpose of this proposal is to show you why improving the efficiency of the current information systems that is being used in the sales department will benefit Party Plates. The sales department is currently using Microsoft Excel and would like to move to another relational database such as Microsoft Access. Team A will be addressing how converting from Excel to Access will help the company, and the advantages of using Access and the disadvantages of using Excel. Team A will also introduce collaborative software and how it is used and what it will do for the company. Team A will also explain how the change will affect the internal communication and how the company can benefit for the change of software.
Microsoft Excel is an electronic spreadsheet program which is used to store, organize, and handle data. It is a grid that consists of rows which consists of numbers, columns which consists of letters, and cells which is the unit that is used to store data. It can also be used for graphing, sorting, and filtering data. (About.com Spreadsheets, 2012)
Microsoft Access is a tool used to manage information which helps store information for references, reports, and analysis. It also helps to manage huge sums of information. (OpenGates Software, 2012) Microsoft Access consists of Tables, Relationships, Queries, Forms, Reports, Macros, and Modules. (SimplyAccess, 2012)
Software that will also help improve communication includes terminal emulators, file transfer programs, chat and instant messaging. (Ask, 2012) It is a program that transmits files between computers. (techopedia, 2010)
CONVERTING FROM EXCEL TO ACCESS
When using Excel you normally use one worksheet to handle all of
BIS/220
July 23, 2012
Efficiency and Collaboration Proposal
Mr. Bob Jenkins
Party Plates, Inc.
8462 Anywhere Lane
Smalltown, AZ. 00000
July 23, 2012
Subject: Efficiency and Collaboration Proposal
INTRODUCTION
The purpose of this proposal is to show you why improving the efficiency of the current information systems that is being used in the sales department will benefit Party Plates. The sales department is currently using Microsoft Excel and would like to move to another relational database such as Microsoft Access. Team A will be addressing how converting from Excel to Access will help the company, and the advantages of using Access and the disadvantages of using Excel. Team A will also introduce collaborative software and how it is used and what it will do for the company. Team A will also explain how the change will affect the internal communication and how the company can benefit for the change of software.
Microsoft Excel is an electronic spreadsheet program which is used to store, organize, and handle data. It is a grid that consists of rows which consists of numbers, columns which consists of letters, and cells which is the unit that is used to store data. It can also be used for graphing, sorting, and filtering data. (About.com Spreadsheets, 2012)
Microsoft Access is a tool used to manage information which helps store information for references, reports, and analysis. It also helps to manage huge sums of information. (OpenGates Software, 2012) Microsoft Access consists of Tables, Relationships, Queries, Forms, Reports, Macros, and Modules. (SimplyAccess, 2012)
Software that will also help improve communication includes terminal emulators, file transfer programs, chat and instant messaging. (Ask, 2012) It is a program that transmits files between computers. (techopedia, 2010)
CONVERTING FROM EXCEL TO ACCESS
When using Excel you normally use one worksheet to handle all of
References: About.com Spreadsheets. (2012). What is Microsoft Excel and When Would I Use it? Retrieved from http://spreadsheets.about.com/od/tipsandfaqs/f/excel_use.htm Ask. (2012, January 24). Communication software. Retrieved from http://www.ask.com/wiki/Communication_software? Grauer, R. T., Poatsy, M. A., Mulberry, K., Hulett, M., Krebs, C., & Keith, M. (2011). Microsoft Office 2010. Upper Saddle River, NJ: Pearson Prentice Hall. Introduction to Collaborative Software. (2012). usability first. Retrieved from http://www.usabilityfirst.com/about-usability/web-application-design/collaborative-software-groupware/introduction-to-collaborative-software/ OpenGates Software. (2012). What is Microsoft Access Used For? Retrieved from http://www.opengatesw.net/ms-access-tutorials/What-Is-Microsoft-Access-Used-For.htm Protusada, J. (2008). Pro-Business Excel VBA Programming. Retrieved from http://msexcelvba.blogspot.com/2008/05/%20advantages SimplyAccess. (2012). What is Microsoft Access. Retrieved from http://www.simply-access.com/What-Is-Microsoft-Access.html What is Collaboration. (2011). Enterprise Content Management. Retrieved from http://www.contentmanager.eu.com/collaboration.htm techopedia. (2010-2012). Communication Software. Retrieved from http://www.techopedia.com/definition/25706/communication-software