Efficiency and Collaboration Proposal Team C
Efficiency and Collaboration Proposal Team C
BIS/220
July 14, 2014
Introduction
Team “C” would like to propose a convenient and efficient system that will allow the company to function in a more proficient manner. The purpose of this proposal is to introduce a relational database system that will improve the company’s productivity by updating our current information system. Team C will demonstrate this by explaining the usefulness of converting data currently in Microsoft Excel spreadsheets into a rational database using Microsoft Access. Describe the benefits of using Microsoft Access in our organization and will include suggestions for the future use of collaborative software, showing how it can improve the communication of the sales department while also streamlining the work process.
In order to streamline work progress for the sales department in decorative paper plates and napkins for special events, the following plan has been set in place. The information systems currently being utilized are Microsoft and Excel in tracking all personal data for the business. The proposal is to integrate an informational system that will collaborate those two systems and improve internal communications. For a clear understanding, please refer to diagram one.
Diagram 1
According to "10 Reasons to Use Access with Excel" (2007), “Peel back Access a layer at a time
Overview of Access users and features
Callout 1 Use Access in three ways: as an occasional user, a power user, or a developer.
Callout 2 Tables, queries, forms, and reports build upon each other and makeup the heart of a database application.
Callout 3 Occasional users have wizards, property builders, the Office Fluent user-interface, and Excel-like features to quickly get a job done.
Callout 4 Power users have macros, the property pane, expressions, and database design tools to delve deeper and do more.
Callout 5
BIS/220
July 14, 2014
Introduction
Team “C” would like to propose a convenient and efficient system that will allow the company to function in a more proficient manner. The purpose of this proposal is to introduce a relational database system that will improve the company’s productivity by updating our current information system. Team C will demonstrate this by explaining the usefulness of converting data currently in Microsoft Excel spreadsheets into a rational database using Microsoft Access. Describe the benefits of using Microsoft Access in our organization and will include suggestions for the future use of collaborative software, showing how it can improve the communication of the sales department while also streamlining the work process.
In order to streamline work progress for the sales department in decorative paper plates and napkins for special events, the following plan has been set in place. The information systems currently being utilized are Microsoft and Excel in tracking all personal data for the business. The proposal is to integrate an informational system that will collaborate those two systems and improve internal communications. For a clear understanding, please refer to diagram one.
Diagram 1
According to "10 Reasons to Use Access with Excel" (2007), “Peel back Access a layer at a time
Overview of Access users and features
Callout 1 Use Access in three ways: as an occasional user, a power user, or a developer.
Callout 2 Tables, queries, forms, and reports build upon each other and makeup the heart of a database application.
Callout 3 Occasional users have wizards, property builders, the Office Fluent user-interface, and Excel-like features to quickly get a job done.
Callout 4 Power users have macros, the property pane, expressions, and database design tools to delve deeper and do more.
Callout 5
References: 10 reasons to use access with Excel. (2007). Retrieved from http://office.microsoft.com/en-us/excel- help/top-10-reasons-to-use-access-with-excel-HA010264081.aspx Rainer, R. K. & Cegielski, C. G. (2011). Introduction to Information Systems: Supporting and transforming business (3rd ed.). Hoboken, NJ: John Wiley & Sons.