1,089
18
Essay, 2 pages (500 words)

Bis 220 wk 4

Efficiency and Collaboration Proposal Cynthia Vargas, Carmen Calvillo, Greg Rudie BIS/220 July 18, 2011 Dr. Kathryn Moland, PhD Efficiency and Collaboration Proposal The purpose of this proposal is to address the efficiencies Party Plates may realize by migrating to a relational database system such as Microsoft Access. The current system we are using is Microsoft Excel, which has served the company well. The following will outline the benefits Access has to offer and how they apply to Party Plates business. Benefits of Access

Microsoft Access has evolved into very user friendly tool and has become simple to learn. It provides for the easier adding, subtracting, and altering of data once the database. Access offers the ability to construct queries to extract reports from the database to analyze all aspects of the data captured in the database (Grauer, 2011). Whereas this is possible in Excel, it is much more cumbersome. Access also offers the ability for more than one user to update tables at the same time but will not allow for the updating of one record by two individuals at the same time.

Access offers the ability to apply rules while entering data so the product will contain the data needed to make calculated business decisions. Access offers the ability to create many reports from the same data set to learn different things about the business (Debasis, 2009). Benefits of Converting Current Data to Microsoft Access By converting the data we currently hold in Microsoft Excel spreadsheets to Microsoft Access, we will be able to track different aspects of our business more effectively.

We will also be able to use the reports we will be able to run to drive positive business results. Building a database to capture the data surrounding our business we will be better able to employee records. Once all of the data has been entered in Access, we will be able to track sales trends by associate. We will also be able to track the buying patterns of our customers allowing us to stock the appropriate items by sales surges.

Our sales force will be able to use the database to more effectively streamline their work and understand how to be more productive with our customers. While many of the items listed above are possible in Microsoft Excel, the data must be inputted to the spreadsheets and work books and can be more difficult to find the information the user is looking for. Conclusion In conclusion, we believe that converting our data currently held in Microsoft Excel to Microsoft Access holds many benefits for the company.

The added ability to analyze data from all aspects of our business will give us the ability to target our weakest performing areas of the business and make them more profitable. Moving to Access will also give us the ability to more effectively enter records and data by more than one individual. References Debasis, D. (2009, July 1). Bright Bulb. Retrieved 7 18, 2011, from brightbulb. com: http://www. brighthub. com/computing/windows-platform/articles/41003. aspx Grauer, R. P. (2011). Micrsoft Office 2010 (Vol. Volume 1). Upper Saddle River, NJ: Pearson Prentice Hall.

Thank's for Your Vote!
Bis 220 wk 4. Page 1
Bis 220 wk 4. Page 2
Bis 220 wk 4. Page 3

This work, titled "Bis 220 wk 4" was written and willingly shared by a fellow student. This sample can be utilized as a research and reference resource to aid in the writing of your own work. Any use of the work that does not include an appropriate citation is banned.

If you are the owner of this work and don’t want it to be published on AssignBuster, request its removal.

Request Removal
Cite this Essay

References

AssignBuster. (2022) 'Bis 220 wk 4'. 18 January.

Reference

AssignBuster. (2022, January 18). Bis 220 wk 4. Retrieved from https://assignbuster.com/bis-220-wk-4/

References

AssignBuster. 2022. "Bis 220 wk 4." January 18, 2022. https://assignbuster.com/bis-220-wk-4/.

1. AssignBuster. "Bis 220 wk 4." January 18, 2022. https://assignbuster.com/bis-220-wk-4/.


Bibliography


AssignBuster. "Bis 220 wk 4." January 18, 2022. https://assignbuster.com/bis-220-wk-4/.

Work Cited

"Bis 220 wk 4." AssignBuster, 18 Jan. 2022, assignbuster.com/bis-220-wk-4/.

Get in Touch

Please, let us know if you have any ideas on improving Bis 220 wk 4, or our service. We will be happy to hear what you think: [email protected]