Efficiency and Collaboration Proposal - Coursework Example

Proposal for Collaboration and Efficiency in Information Management System By __________ 28th November Introduction Information system is an indispensible tool of management for businesses in modern era. Organizations prefer high end technology so that they can ease the workload and derive assistance in data management. Australian Bureau of Statistics (1998) stated that a strong relationship exists between the number of personnel in an organization and the likelihood that the business in using IT because as the number increases so does the proportion of businesses using IT services (1998, p.643). Party Plates is decorative paper plate manufacturing company that uses Microsoft Excel to track all personnel data.

However, it is not denied that Microsoft Excel can be used in various others ways like inventory, financial worksheets, etc. But Microsoft Access is a Relational Database Management System (RDBMS) application which is primarily meant for maintaining records whereas Microsoft Excel’s primary function is to act as a tool for data analysis. As it is necessary to maintain records of personnel working in the organization, an application is essential which can be used to enter the records and provide reports based on various parameters, Microsoft Access is flexible and useful when compared to Microsoft Excel.

Importing current data from Microsoft Excel to Microsoft Access Microsoft Office is a easiest tool for documentation, tables, analysis, making presentation, maintaining records and getting reports. All the applications in MS Office package are flexible with each other that the data can be imported and exported to different applications. Similarly, all the data existing in MS Excel can be imported in MS Access through Import Option available in MS Access. This not allow the data to imported but it actually imports the data head-wise as it was entered in Excel thus eliminating the problem of entering the data again in Excel.

Benefits of Microsoft AccessThe main benefit of MS Access is that value can be given to the parameters and based on these values data can be entered and reports can generated. Additionally, it offers the flexibility to design report based on our conditions. Such reports can help the organizations in decision making process. Party Plates can use MS Access to its fullest extent as possible to derive data as per its requirement and generate reports to make necessary changes in its strategy. Information pertaining to personnel’s can be obtained category wise to determine the payment policies, costs, products, sales data, etc.

Such detailed data will help the sales department in taking decisions regarding the strategy formulation in times of crisis. Suggestions for the future collaborative software As the competition is intense in the market, it is necessary that businesses upgrade themselves to high end information technology services. Microsoft SharePoint is innovative application which helps to reduce the training and maintenance costs, saves time and focuses on higher business priorities (MS SharePoint). This application also supports all the features like importing, exporting, report generation, etc.

to assits the businesses to arrive at a concrete solution. There are other software like Zoho who integrate with the services of SharePoint, but the latter is more proficient in terms of effective service. Therefore it is suggested to deploy SharePoint software to improve the efficiency in sales department. References1. Australian Bureau of Statistics (1998) Year Book – Australia, Issue 80, No. 87, Australian Bureau of Statistics: Canberra 2. MS SharePoint (2010) Why Use SharePoint 2010? [Online] Available at: Accessed on 28th November 2011.