Efficiency and Collaboration Proposal
Efficiency and Collaboration Proposal
Party Plates has been very successful over many years. The proposal will detail the benefits of changing databases and future use of collaborative software. Improvements in the current information systems used in the sales department equals efficiency.
The first improvement will include switching the personnel data system from Microsoft Excel to Microsoft Access. Excel has served basic purposes, however the system is antiquated. Excel is user-friendly, but has the company grows the lack luster tools are not enough for future uses.
Excel database uses (Grauer et al., 2011, p. 554):
1. Only need one worksheet to handle all of your data (i.e., you do not need multiple worksheets), 2. Have mostly numeric data—for example, you need to maintain an expense
Statement,
3. Require subtotals and totals in your worksheet,
4. Want to primarily run a series of “what if” scenarios on your data,
5. Need to create complex charts and/or graphs.
The major problem lies in expanding and tracking the information in the database. Additional columns, rows and worksheets can be added. Tracking information becomes cumbersome flipping through worksheets and as the database increases more organization is required.
Access database uses (Grauer et al., 2011, p. 554):
1. Require multiple related tables to store your data,
2. Have a large amount of data,
3. Need to connect to and retrieve data from external databases, such as Microsoft SQL Server,
4. Need to group, sort, and total data based on various parameters,
5. Have an application that requires multiple users to connect to one data source at the same time.
The built in tools provided by Access helps with better organization. Improved tools are equal efficiency in the work environment combining data from various forms, reports, queries and tables.
Access will be the key to database efficiency. Collaborative software is also needed to improve communication and streamline
Party Plates has been very successful over many years. The proposal will detail the benefits of changing databases and future use of collaborative software. Improvements in the current information systems used in the sales department equals efficiency.
The first improvement will include switching the personnel data system from Microsoft Excel to Microsoft Access. Excel has served basic purposes, however the system is antiquated. Excel is user-friendly, but has the company grows the lack luster tools are not enough for future uses.
Excel database uses (Grauer et al., 2011, p. 554):
1. Only need one worksheet to handle all of your data (i.e., you do not need multiple worksheets), 2. Have mostly numeric data—for example, you need to maintain an expense
Statement,
3. Require subtotals and totals in your worksheet,
4. Want to primarily run a series of “what if” scenarios on your data,
5. Need to create complex charts and/or graphs.
The major problem lies in expanding and tracking the information in the database. Additional columns, rows and worksheets can be added. Tracking information becomes cumbersome flipping through worksheets and as the database increases more organization is required.
Access database uses (Grauer et al., 2011, p. 554):
1. Require multiple related tables to store your data,
2. Have a large amount of data,
3. Need to connect to and retrieve data from external databases, such as Microsoft SQL Server,
4. Need to group, sort, and total data based on various parameters,
5. Have an application that requires multiple users to connect to one data source at the same time.
The built in tools provided by Access helps with better organization. Improved tools are equal efficiency in the work environment combining data from various forms, reports, queries and tables.
Access will be the key to database efficiency. Collaborative software is also needed to improve communication and streamline
References: Grauer, R. T., Poatsy, M. A., Mulbery, K., Hulett, M., Krebs, C., & Mast, K. (2011). Microsoft® Office 2010: Volume 1. Upper Saddle River, NJ: Pearson Prentice Hall Rudo, P. (2012, September 16). How to drive sales through collaboration software. Retrieved from http://enterprisefeatures.com/2012/09/how-to-drive-sales-through-collaboration-software/