The Big Switch
The Big Switch
Sharandon Primm, Alan Harville, Jonathan Leverette, Kimberli Fletcher, and Dulce Cadogan
Business 220
May 16, 2013
Gary LaRoy
The Big Switch
The president of our company has brought to our attention that he would appreciate it if our department could create a new information system for our company. The current information system that we use is Microsoft Excel and we need to create a way to transfer and implement the new office system of Microsoft Access. We need to explain the current downsides to using Microsoft Excel and explain the positive ways by using Microsoft Access that will help our company grow, expand, and be more efficient to our company. We also need to come up with software that is compatible to Microsoft Access just to have a contingency plan, in case the president is not pleased with the results we research and to help improve the internal communications along with help make the workflow of the sales department improve. We do know that the current plan is not working for our company and we need to all work diligently to improve our current system and make the transition easy.
Microsoft office is a great tool and Excel, when used properly, is a valuable asset. The problem with Microsoft Excel is that there are various manual inputs that can go wrong. Other common problems that can cause an error involve not using a colon to indicate a range of cells, forgetting to close your parentheses, and adding common formats as part of the formula (Murray, 2013). The formulas that Excel uses would be complicated to track everything. (Murray, 2013) It is also very difficult to track the history of changes that our company uses has it moves forward. This would not only hinder the company but could possibly cause miscommunication of the data inputted. (Murray, 2013) These reasons stated above are why the company should not use the Excel program to move forward in the progression of the company.
With Access, it is a relational database
Sharandon Primm, Alan Harville, Jonathan Leverette, Kimberli Fletcher, and Dulce Cadogan
Business 220
May 16, 2013
Gary LaRoy
The Big Switch
The president of our company has brought to our attention that he would appreciate it if our department could create a new information system for our company. The current information system that we use is Microsoft Excel and we need to create a way to transfer and implement the new office system of Microsoft Access. We need to explain the current downsides to using Microsoft Excel and explain the positive ways by using Microsoft Access that will help our company grow, expand, and be more efficient to our company. We also need to come up with software that is compatible to Microsoft Access just to have a contingency plan, in case the president is not pleased with the results we research and to help improve the internal communications along with help make the workflow of the sales department improve. We do know that the current plan is not working for our company and we need to all work diligently to improve our current system and make the transition easy.
Microsoft office is a great tool and Excel, when used properly, is a valuable asset. The problem with Microsoft Excel is that there are various manual inputs that can go wrong. Other common problems that can cause an error involve not using a colon to indicate a range of cells, forgetting to close your parentheses, and adding common formats as part of the formula (Murray, 2013). The formulas that Excel uses would be complicated to track everything. (Murray, 2013) It is also very difficult to track the history of changes that our company uses has it moves forward. This would not only hinder the company but could possibly cause miscommunication of the data inputted. (Murray, 2013) These reasons stated above are why the company should not use the Excel program to move forward in the progression of the company.
With Access, it is a relational database
References: Microsoft. (2013, March). Microsoft Access. Retrieved from http://www.office.microsoft.com Murray, K. (May, 2013). Five tips for troubleshooting formulas in Excel. Retrieved from http://www.techrepublic.com