Efficiency and Collaboration Proposal

Efficiency and coaction Proposal Learning Team D Terry Hooks, Dante Legare, Reginald Mitchell, Javier Sanchez, and Stephanie Wright University of Phoenix BIS/220 Lakeesha Seawood November 10, 2011 Efficiency and Collaboration Microsoft outgo to Microsoft devil Benefits in the Work Environment The benefits of using Microsoft Access in the work environment for the Party Plates familiarity would be the ease of creating contacts, issue tracking, project tracking, and asset tracking, (Software-Matters, 2011).This program would serve the company by maintaining the menstruum clients and customers previous orders, attach receipts, shipment orders, and any other documents directly to their profile. The company leave behind be adapted to forecast future orders and share the information across the company using Windows SharePoint Services. Using this option ordain help the employees share information, back up the data, and will ultimately keep everybody working in a joint collaborati ve effort. Reginald MitchellThe excel spreadsheets that are currently being used work primarily despatch of memory. If the save icon is not clicked all work will be lost if the program is unlikable accidently. The same tragedy can happen if there is a power loss as well. The benefits of using admission price are it works primarily off of storage. The data that is entered is automatically deliver and the database is updated. While using access more than one person can work on the same file at one time. Excel only allows one person to use the spreadsheet at one time.Stephanie Wright Information from Excel Excel Exported to Acces. Examples of Tables, Reports and Queries. Javier Sanchez Suggestions for Improvement The implantation of the Transaction Processing System will help the company to monitor, collect, computer memory and process data generated from the daily transaction. This formation will re issue the antiquated system that is in place currently. Transaction processing s ystem Transaction processing system Transaction Transaction handicraft database Business database Detailed reportsDetailed reports Paper plates Paper plates The data that is collected from transactions are placed into batches. This system is called Batch Processing. Using collaborative software such as Peachtree by Sage (www. peachtree. com) will help the company manage their financial transactions. Using this software the company will have access to gross revenue ledgers, purchase ledgers, sales order processing. Stephanie Wright Conclusion In conclusion, the Party Plates Company would have easier access to apposite data.By manipulating handle and properly formulating the travails required in an excel spreadsheet, the company can track what is postulate in each department and apply it to its database more efficiently. The Party Plates Company can also quick make reports from each department within the company. For example, if the Supervisor or section Manager of the Human Re sources Department wanted a report on all personnel that had missed more than five days of work over a three month period, excluding holidays, vacations, and maternity leave.He or she would simply access the database and simply click the required field to receive the answers desired for the report in particular. With excel simply this would be more of a tedious task. With excel one could enter the data in fields and have such data imported to access to be stored. This helps every business because the data is saved and can be retrieved at a later date if necessary for reports, strategy building, and brain storming impertinent products or projects.If a database is built with the proper parameters the product will be more conclusive for the task of the company, or a department within the company that the database is built. In summary the implantations of the various information systems will allow the company to operate more effectively. Dante L. LeGare Reference Software-Matters. 20 11. Microsoft Office Access benefits. Software-Matters. Retrieved from http//www. software-matters. co. uk/microsoft-access-benefits. html.