Efficiency Proposal
In a continually growing and functioning company, one has to make sure they are making the right decisions in growth. In the decision to grow from excel to access there are quite a few benefits. In addition to this, it is a great idea to promote quick communication and sharing between coworkers to increase efficiency and communication avenues to both remote and local workers. Access is a great program that offers many benefits. While it may not be as easy to use as excel, it allows for relating data easily and allows it to grow easily without being bogged down as quickly. Another great benefit is the ability to do queries and create reports based on the data that has been entered. Lastly, it is a little easier to make mistakes on Excel, for example if you add more data you have to update all your formulas to include the new data as well, which could be easily overlooked on accident.
A relational table, which is what this team proposes, is the easiest table to create and use. It allows for very simple database that has all the information is rows and columns for you to look at. Typically, all of the information is not on one file, but in many tables that are related to each other instead. The information is then able to be compared to one another if there are similar columns between the separate tables. This is important because it keeps the files in manageable sizes, and still allows the flexibility of creating reports and being able to search through the information quickly with queries.
Lastly, there is a plethora of collaborative software at the disposal of the company, but two that stand out are Google Docs and Microsoft’s SharePoint. What is nice about Google Docs is that it is a free software and it is very easy to use. The downfalls is that it allows everyone to edit at the same time, and it is harder to control what happens to the documents within. On the other hand Micrsoft’s SharePoint allows for more control to what happens to the documents
A relational table, which is what this team proposes, is the easiest table to create and use. It allows for very simple database that has all the information is rows and columns for you to look at. Typically, all of the information is not on one file, but in many tables that are related to each other instead. The information is then able to be compared to one another if there are similar columns between the separate tables. This is important because it keeps the files in manageable sizes, and still allows the flexibility of creating reports and being able to search through the information quickly with queries.
Lastly, there is a plethora of collaborative software at the disposal of the company, but two that stand out are Google Docs and Microsoft’s SharePoint. What is nice about Google Docs is that it is a free software and it is very easy to use. The downfalls is that it allows everyone to edit at the same time, and it is harder to control what happens to the documents within. On the other hand Micrsoft’s SharePoint allows for more control to what happens to the documents
References: Rainer, R. K., & Cegielski, C. G. (2011). Introduction to information systems (3rd ed.). Hoboken, N.J.: Wiley.