Preview

Efficiency & Collaboration Proposal

Good Essays
Open Document
Open Document
828 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Efficiency & Collaboration Proposal
Efficiency and Collaboration Proposal Norris Johnson
BIS/220
July 23, 2012

Efficiency and Collaboration Proposal
Mr. Bob Jenkins
Party Plates, Inc.
8462 Anywhere Lane
Smalltown, AZ. 00000

July 23, 2012

Subject: Efficiency and Collaboration Proposal

INTRODUCTION

The purpose of this proposal is to show you why improving the efficiency of the current information systems that is being used in the sales department will benefit Party Plates. The sales department is currently using Microsoft Excel and would like to move to another relational database such as Microsoft Access. Team A will be addressing how converting from Excel to Access will help the company, and the advantages of using Access and the disadvantages of using Excel. Team A will also introduce collaborative software and how it is used and what it will do for the company. Team A will also explain how the change will affect the internal communication and how the company can benefit for the change of software.
Microsoft Excel is an electronic spreadsheet program which is used to store, organize, and handle data. It is a grid that consists of rows which consists of numbers, columns which consists of letters, and cells which is the unit that is used to store data. It can also be used for graphing, sorting, and filtering data. (About.com Spreadsheets, 2012)
Microsoft Access is a tool used to manage information which helps store information for references, reports, and analysis. It also helps to manage huge sums of information. (OpenGates Software, 2012) Microsoft Access consists of Tables, Relationships, Queries, Forms, Reports, Macros, and Modules. (SimplyAccess, 2012)

Software that will also help improve communication includes terminal emulators, file transfer programs, chat and instant messaging. (Ask, 2012) It is a program that transmits files between computers. (techopedia, 2010)
CONVERTING FROM EXCEL TO ACCESS

When using Excel you normally use one worksheet to handle all of


References: About.com Spreadsheets. (2012). What is Microsoft Excel and When Would I Use it? Retrieved from http://spreadsheets.about.com/od/tipsandfaqs/f/excel_use.htm Ask. (2012, January 24). Communication software. Retrieved from http://www.ask.com/wiki/Communication_software? Grauer, R. T., Poatsy, M. A., Mulberry, K., Hulett, M., Krebs, C., & Keith, M. (2011). Microsoft Office 2010. Upper Saddle River, NJ: Pearson Prentice Hall. Introduction to Collaborative Software. (2012). usability first. Retrieved from http://www.usabilityfirst.com/about-usability/web-application-design/collaborative-software-groupware/introduction-to-collaborative-software/ OpenGates Software. (2012). What is Microsoft Access Used For? Retrieved from http://www.opengatesw.net/ms-access-tutorials/What-Is-Microsoft-Access-Used-For.htm Protusada, J. (2008). Pro-Business Excel VBA Programming. Retrieved from http://msexcelvba.blogspot.com/2008/05/%20advantages SimplyAccess. (2012). What is Microsoft Access. Retrieved from http://www.simply-access.com/What-Is-Microsoft-Access.html What is Collaboration. (2011). Enterprise Content Management. Retrieved from http://www.contentmanager.eu.com/collaboration.htm techopedia. (2010-2012). Communication Software. Retrieved from http://www.techopedia.com/definition/25706/communication-software
Continue Reading
View Writing Issues

You May Also Find These Documents Helpful

  • Good Essays

    Efficiency and Collaboration Proposal
    • 745 Words
    • 3 Pages

    Efficiency and Collaboration Proposal

    Party Plates is currently using the information system identified as Microsoft Excel. While this is a great program and has been very useful for our business practices thus far, our team has collaborated upon a recommendation for the implementation of converting to the Microsoft Access database. To keep up with the current growth of our customer base, we know that this conversion is necessary. Microsoft Access assists employees to swiftly record and account for information with the ability of Microsoft Office Fluent user’s interaction with its design capabilities that do not necessitate intense database knowledge. The practice of creating a group within a group and then performing calculations are far more complicated in Excel. With Office Access, one has the ability to link tables to his or her database from other Access databases, Windows SharePoint Services sites, ODBC data sources, Excel spreadsheets, Microsoft SQL Server databases, and other data sources. One can then link tables easily to generate reports; thereby, one can base his or her decisions on a more inclusive set of information. Users are able to share data over the internet on Microsoft Office SharePoint Server. Databases are good for finding relationships in data. Spreadsheets are excellent when performing "what if" analysis and working with numbers.…

    • 745 Words
    • 3 Pages
    Good Essays
    Read More
  • Good Essays

    It206 Wk4 Scenarios
    • 918 Words
    • 4 Pages

    It206 Wk4 Scenarios

    A business professional wants to use Microsoft® Excel® to organize data for the monthly expense report. He has never used Microsoft® Excel® and is inquiring about the functions that would support him with this task.…

    • 918 Words
    • 4 Pages
    Good Essays
    Read More
  • Satisfactory Essays

    It/205 Key Computer Terms Checkpoint
    • 365 Words
    • 2 Pages

    It/205 Key Computer Terms Checkpoint

    | The software that enables one or a company to store, organize and retrieve information.…

    • 365 Words
    • 2 Pages
    Satisfactory Essays
    Read More
  • Powerful Essays

    Bsc303 Chapter 1 Study Guide
    • 4685 Words
    • 19 Pages

    Bsc303 Chapter 1 Study Guide

    You use wordprocessing software to create and edit written documents. Spreadsheet software enables you to do calculations and numerical and what-if analyses easily. Presentation software enables you to create slide presentations. Personal information manager (PIM) software helps keep you organized by putting a calendar, address book, notepad, and to-do lists within your computer. Database programs are electronic filing systems that allow you to filter, sort, and retrieve data easily. Individuals can also use software to help with business-like tasks such as preparing taxes or managing personal finances.…

    • 4685 Words
    • 19 Pages
    Powerful Essays
    Read More
  • Good Essays

    The Lady with the Dog
    • 554 Words
    • 3 Pages

    The Lady with the Dog

    Ed. Allison Booth and Kelly J. Mays. New York: W.W. Norton & Company. 165-178. 2011.…

    • 554 Words
    • 3 Pages
    Good Essays
    Read More
  • Good Essays

    Microsoft Word, Excel and Powerpoint
    • 299 Words
    • 2 Pages

    Microsoft Word, Excel and Powerpoint

    Microsoft Excel is an electronic spreadsheet program that can be used for storing, organizing and manipulating data. Microsoft Excel is made up of little squares on the screen. You can also resize the columns in Microsoft Excel to adjust to the size you need them to be. You can put information such as data types that can hold numbers, text or formulas. Some employers in the workplace use Microsoft Excel to keep records of information, accounts of people, financial information, and to create graphs or charts.…

    • 299 Words
    • 2 Pages
    Good Essays
    Read More
  • Better Essays

    Adolescent Years
    • 1973 Words
    • 8 Pages

    Adolescent Years

    References: Pruitt, Sheila Tucker B.E., Stein, Jane J., Cummings, Benjamin, Blake, Joan Salge, Thompson, Janice, Mel .…

    • 1973 Words
    • 8 Pages
    Better Essays
    Read More
  • Powerful Essays

    Access To Health Care Research Paper
    • 1409 Words
    • 6 Pages

    Access To Health Care Research Paper

    Buerhaus, P. I., DesRoches, C., Applebaum, S., Hess, R., Norman, L. D., & Donelan, K. (2012).…

    • 1409 Words
    • 6 Pages
    Powerful Essays
    Read More
  • Good Essays

    Benefits of Access in Workplace
    • 317 Words
    • 2 Pages

    Benefits of Access in Workplace

    Overall Microsoft Access will bring tremendous benefits to our company and ease to the workload of our employees. This software will allow an efficient…

    • 317 Words
    • 2 Pages
    Good Essays
    Read More
  • Good Essays

    Spreadsheet Programs Besides Excel
    • 2266 Words
    • 10 Pages

    Spreadsheet Programs Besides Excel

    A major one was the spreadsheet application, the very first, Visicalc which was developed in the year 1979. Today, the most popular spreadsheet can be said to be Microsoft Excel which was developed in the 1980’s. The purpose of this term-paper is to introduce at other spreadsheets other than Microsoft Excel.…

    • 2266 Words
    • 10 Pages
    Good Essays
    Read More
  • Better Essays

    MS Office integration
    • 1222 Words
    • 5 Pages

    MS Office integration

    References: Bott, E., & Leonhard, W. (2013). Using Microsoft Office 2013. Indianapolis, IN: Que Publishing.…

    • 1222 Words
    • 5 Pages
    Better Essays
    Read More
  • Better Essays

    8 Golden
    • 1366 Words
    • 6 Pages

    8 Golden

    Microsoft Excel 2010 for windows could categorize as one of the best spreadsheet processor ever made. It has a wide range of functions that uses for personal use and business use. Concerning the functionality that the application providing the user interface designing team has done a very good to make it user friendly and easy to learn even though there are few up and downs with the 8 golden rules.…

    • 1366 Words
    • 6 Pages
    Better Essays
    Read More
  • Powerful Essays

    computer application in business
    • 23713 Words
    • 95 Pages

    computer application in business

    COMPUTER APPLICATION FOR BUSINESS BCOMP1101 STUDENT NOTES FACULTY OF BUSINESS MANAGEMENT & GLOBALIZATION COMPUTER APPLICATION FOR BUSINESS INSTRUCTOR MANUAL  Limkokwing Executive Leadership College Inovasi 2-3, Jln Teknokrat 1/1 63000 Cyberjaya Selangor Darul Ehsan, Malaysia Phone 603.8317.8811 • Fax 603.8317.8338 © Microsoft Corporations ii T able of Contents CHAPTER 1 ▬ INTRODUCTION TO MICROSOFT EXCEL 2003 3.2.1 Relative, Absolute & Mixed Cell References 2003 2 1.2 What is a Spreadsheet? 2 1.3 Microsoft Excel 2003 User Interface 3 1.4 Starting Microsoft Excel 2003 4 1.5 Types of Cell Entries 5 1.6 Identifying Toolbars and Buttons 6 1.7 Identifying Menus and Commands 8 1.8 Opening Excel Files 9 1.9 Saving Excel Files 10 1.10 Closing Excel Files 10 Summary 11 24 3.2.2 3-D Cell Reference 27 3.2.3 Consolidating Cell Reference 27 3.3 Advance Formatting Cells 1.1 Introduction to Microsoft Excel 28 3.3.1 Conditional Formatting 34 3.4 Navigating In Excel 35 Summary 35 CHAPTER 4 ▬ GRAPHS AND CHARTS 4.1 What is a Chart? 37 4.2 Chart Types 37 4.3 Creating a Chart using Chart 41 4.4 Choose Chart Type 43 4.5 Check Data Series 43 4.6 Complete Chart Option 45 4.7 Chart Location 45 4.8 Modifying Chart 46 4.9 Enhancing Chart 46 4.10 Moving and Resizing Chart 46 4.11 Multiple Data Series 47 4.12 Object Linking and Embedding 47 Summary CHAPTER 2 ▬ DEVELOPING A PROFESSIONAL LOOKING WORKSHEET Wizards 48 2.1 Create Workbook and Multiple Worksheet 12 2.2 Enter Text and Numbers 13 2.3 Use Simple Functions (Sum) and Formulas 14 2.4 Simple Formatting 15 2.5 Page Setup and Orientation 17 2.6 Printing Workbook 18 Summary 18 CHAPTER 5 – DECISION MAKING IN SPREADSHEETS 5.1 PMT Function 5.2 FV Function 51 5.3 Goal…

    • 23713 Words
    • 95 Pages
    Powerful Essays
    Read More
  • Good Essays

    The Big Switch
    • 554 Words
    • 3 Pages

    The Big Switch

    The president of our company has brought to our attention that he would appreciate it if our department could create a new information system for our company. The current information system that we use is Microsoft Excel and we need to create a way to transfer and implement the new office system of Microsoft Access. We need to explain the current downsides to using Microsoft Excel and explain the positive ways by using Microsoft Access that will help our company grow, expand, and be more efficient to our company. We also need to come up with software that is compatible to Microsoft Access just to have a contingency plan, in case the president is not pleased with the results we research and to help improve the internal communications along with help make the workflow of the sales department improve. We do know that the current plan is not working for our company and we need to all work diligently to improve our current system and make the transition easy.…

    • 554 Words
    • 3 Pages
    Good Essays
    Read More
  • Satisfactory Essays

    Difference Between Workbook and Worksheet
    • 309 Words
    • 2 Pages

    Difference Between Workbook and Worksheet

    Worksheet in Excel is a combination of a number of cells that contains data relating to a particular piece of information. Otherwise, a worksheet is known as a spreadsheet. A user is capable of entering, modifying, and manipulating the data that is inserted in the spreadsheet. With a worksheet, a user is basically putting information onto a page of a workbook.…

    • 309 Words
    • 2 Pages
    Satisfactory Essays
    Read More

Related Topics