...Efficiency and Collaboration Proposal Alejandra Solórzano, Andres Hernandez, Diana Anchando, Romelia Acosta BIS/220 February 28, 2013 Carlos Guzman Abstract Party Plates is a business currently seeking new and innovated ways to maximize profits as well as employee productivity. The goal is to take a functional system and convert it into a structure that makes all records manageable and easily retrievable. In the process of innovation Party Plates will explore collaborative software that will facilitate communication and assist in sales. Efficiency and Collaboration Proposal As the manager of sales department at Party Plates; we have been considering changing form Microsoft Excel to Microsoft Access. These two products can be compatible to each other; however each as its own purpose and one can help our sales department better than the other (Sanger, 2012). Functions that are different between them are that Access is a relational database management system and can manage large amounts. Accesses can creat4 relationships between data because it uses flat files and can handle thousands of records. Excel is a spreadsheet and dose math. Excel has limited functionality and can handle up to 15,000 records. (Sanger, 2012). On the effort to increase sales, the corporation decided to use Microsoft Excel systems; it helps not also to increase sales but to have a better communication between the employees. The benefits are highly quantify, starting with the internal...
Words: 859 - Pages: 4
...The Efficiency and Collaboration Proposal The use of Microsoft Excel has proven to be effective in tracking personnel data. To help improve efficiency of the current information systems it may prove beneficial to switch to a more relational database like Microsoft Access. In turn, this will help improve internal communication and help streamline some of the work processes for the sales department. Currently the Party Plates Company uses Microsoft Excel to track personnel data in a spreadsheet inputting small amounts of repetitious data each time a record is created. Although Microsoft Excel and Microsoft Access offer some of the same tools such as applying filters, sorting table data, and extracting information, Microsoft Access a relational database, has features to track actions and events in multiple related tables. It offers more built in tools better to organize, track, and to make a relational structure between the tables by using a common field for the purpose of creating queries, forms, and reports large amounts of data than Microsoft Excel. The Party Plates Company would benefit from the use of converting their personnel data from single Microsoft Excel spreadsheets into a relational database, such as Microsoft Access (2012 Microsoft Corporation). There are many benefits that Party Plates would get from using Microsoft Access. The cost is reasonable to the other databases available; this system permits customization of databases making it possible to manage other...
Words: 720 - Pages: 3
...Efficiency & Collaboration Proposal Converting from Microsoft Excel to Microsoft Access would be very beneficial as with Party Plates Company it is great for data management. As they both preform similar functions they still offer different things in the program. Access works both independently and interdependently allowing users to combine data and information from several sources. As access is a data management system it is used best with storing large amounts of data. This will help the party plates company as it can hold information such as: item numbers, quantity, description, and etc. This function is great for a business rather than Excel utilizing tables, as this program is more for calculations and functions in a spreadsheet style. When using Excel it is mainly numerical, non-relational, and used with calculations. If you wanted to share your spreadsheet to a different coworker then it may be more of a hassle if they do not have the same version of Excel as you. Access allows the company to group different thing in access better like colors of plates, size of plates, what customer orders what and their information. As for collaboration software, if the company is already using Microsoft, one might really like using Lync. It can be used an instant message function, as well as share your screen, share documents, video chat, and take notes. All that has to done is be logged in to the account and Lync can automatically load, and connect companies to other companies. Plus...
Words: 415 - Pages: 2
...Efficiency and Collaboration Proposal Maliaka M. McClendon, Tameeka Kelly, Tokisha Payne, Jude McDonald BIS/220 September 22, 2014 Darrell Oakland Efficiency and Collaboration Proposal When it comes to running a business, efficiency is important to both the business and the customers. But what makes the business efficient? The most important programs to run in a business are the database systems as well as the collaboration tools. If you are using a program from Microsoft, Access is the best one to use in the business because of its ability to process information using a relational database system. However, the collaboration tool that a business uses is equally important. This tool whether it is an inter- or intra-net type system is critical when working with other team members or employees to process work efficiently and effectively for the business and its customers. While currently at Party Plates we utilize Microsoft Excel, there is good reason to incorporate Microsoft Access as well. On many occasions, you will want and possibly need to take advantage of the benefits that both programs have to offer. For example, you created a spreadsheet in Excel in which you can calculate and analyze the data, and it has become unmanageable due to size and complexity, and now that data needs to be accessed by many more users than you. One example would be to, import or link your worksheet into Access and use it as a database as an option to working with it in Excel. Whether...
Words: 701 - Pages: 3
...Efficiency and Collaboration Proposal BIS/220 April 16, 2013 Ramin Tabrizi Efficiency and Collaboration Proposal The main purpose of this proposal is to show how changing Party Plates current information system is beneficial. The sales department should consider a relational database such as Microsoft Access versus their current database, Microsoft Excel. Team C will explain the effectiveness of converting data currently held in Microsoft Excel into an interactive database using Microsoft Access. Team C will also introduce types of collaborative software; how this software can improve communications and streamline work processes. It is time for something new, something invigorating and inspirational for this business’ organization. Party Plate’s current system is Microsoft Excel. The system is excellent for managing and maintaining data entry information as well as other electronically processed information. Microsoft Excel has allowed our business to control the inventory and regulate the calculations that are constantly occurring during a daily routine. Excel’s spreadsheet program has allowed this company to create and breakdown prices into rows and sections wherever needed for evaluating values and rates for our customers’ orders and suppliers’ productions. Excel allows us to distinguish between the two as well as the many other values that may be involved in the transaction. Errors are easily corrected that may be found after evaluation is nearly complete. The program...
Words: 754 - Pages: 4
...Efficiency and Collaboration Proposal Learning Team D BIS/220 October 20, 2014 Mr. Keith Hopkins Efficiency and Collaboration Proposal Party Plates A Business Proposal to Improve the Efficiency of our Current Information System used by our Sales Department Our sales department for Party Plates is currently using Microsoft® Excel to keep track of all personnel data. This proposal will provide an explanation as to why we believe Microsoft® Access would be more beneficial to use and other possible software uses. Microsoft® Access provides built-in tools that assists in organizing data that Microsoft® Excel does not. Currently, our personnel data is kept on an Excel spreadsheet. Converting this information to Access will allow Party Plates to share this database within our entire company, so that everyone will have access to it. The best thing that Access can do to impact the use of our personnel data information is that one of the tools allows us to create relationships (Office 2014). Doing so will allow us to efficiently combine data from our database to create forms and reports. With our increasing sales, our sales department will not be able to affectively track our personnel. Therefore, using Microsoft® Access will allow multiple fields instead of worksheets. It will also allow us to have multiple users to use one data source, so that a number of departments can view the data (Office 2014). Social media has taken over everywhere. Individuals use social media...
Words: 612 - Pages: 3
...Efficiency and Collaboration Proposal BIS/220 April 16, 2013 Efficiency and Collaboration Proposal Team “D” would like to propose a convenient and efficient system that will allow the company to function more proficient. 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 D 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. Usefulness Depending on whom you speak with you will get a different response when asked, which software is better Microsoft Excel or Access. They are both very powerful and unique software used by tremendous amount of individual’s worldwide. Just know that both are used to make our day at work or even at home easier by recording and organizing important data. However, how they store, organize, or display that data is completely different from each other making it one of the major differences between the two. For example, excel offers what is known as the what-if analysis, which can forecast the outcome of the worksheet. Although they may seem completely different visually...
Words: 684 - Pages: 3
...Efficiency and Collaboration Proposal BIS/220 Microsoft Access has become more user friendly over the past few years; it has more tools and is very simple for a person to learn, even if they have never used the program before. The system has easier add, subtracting, and also is easier to change data that has previously been entered. Access gives the ability for more than one user to update tables at the same time, and gives the option to create more than one report from the same data. Access stores data in tables that look like worksheets, but are designed for complex querying in relation to data stores in other tables and locations. Access also allows you to use structured query language, to quickly retrieve just certain rows and columns of data that you may want for a report, even if that particular data is part of another table. By converting our data that we currently have in Microsoft Excel to Microsoft Access it will give us the opportunity to track different areas of our business in more ways than one. It will also allow us to effectively maintain our reports to ensure better production and customer satisfaction. Using Microsoft Access as the database for our company is beneficial for so many reasons. For instance, with an access database file, several users can work in the same file at the same time, multiple users, from different computers; can work on an Access database simultaneously. One person could add records to the Customer table while another could create...
Words: 527 - Pages: 3
...Our research is important to our job and well-organized data will allow co-workers to correctly assess, replicate, and evaluate your research results. Microsoft Access supports employees to quickly record and account for information with the ability of Microsoft Office confident user’s interaction with its design abilities that do not require intense database knowledge. Access stores information in the form of tables that are similar to worksheets but are designed for gathering large and various types of data that is stored in other tables and locations, and even in fields in other tables. The practice of creating a group within a group and then performing calculations are far more difficult using Microsoft Excel. In addition, “professional developers have found that Microsoft Office Access can save time and meet business requirements for many applications.” (Microsoft Corporation, 2006) With Microsoft Access, someone can integrate tables, forms, queries to their database from other Access databases. Microsoft SQL (Structured Query Language) Server databases, Windows SharePoint Services sites, ODBC (Open Database Connectivity) data sources, Excel, and other data sources all have the capability to work with Access. (Microsoft Corporation, 2006) Due to the large range of information that can be collected using Microsoft Access, this can make creating reports, sharing with co-workers and time management easier and more effective. Databases are good for finding connections...
Words: 307 - Pages: 2
...Information Systems Proposal BIS/220 July 7, 2014 Contents Types of Information System (IS)……………………………………..3 Benefits & Drawbacks…………………………………………………4 Image of Our Record Store…………………………………………….5 References……………………………………………………………..6 Types of Information Systems (IS) 1. Functional Area Information System * Supports the activities within individual areas of the business/ System to process time keeping. 2. Transactional Processing System * Processes transaction information /Point of Sale terminals for checking out customers. 3. Office Automation System * Keeps track of daily work actions/ Utilizing Excel to create spreadsheets of inventory. 4. Management Information System * Creates reports with summaries of daily transactions/Daily or weekly tracking of revenue and most popular items sale...
Words: 387 - Pages: 2
...Efficiency and Collaboration Proposal Team B BIS/220 September 18, 2012 Instructor Title of Paper The main purpose of this proposal is to show how changing Party Plates current information system is beneficial. The sales department should consider a relational database such as Microsoft Access versus their current database, Microsoft Excel. Team B will explain the usefulness of converting data currently held in Microsoft Excel into a relational database using Microsoft Access. Team B will also introduce types of collaborative software; how this software can improve communications and streamline work processes. Microsoft Excel Microsoft Excel is the most used spreadsheet program (Grauer, Poatsy, Mulbery, Hulett, Krebs, & Mast, 2011). In Excel, a worksheet is a single spreadsheet that typically contains descriptive labels, numeric values, formulas, functions, and graphical representations of data (Grauer, Poatsy, Mulbery, Hulett, Krebs, & Mast, 2011). A workbook is a collection of one or more related worksheets contained within a single file; by default, new workbooks contain three worksheets (Grauer, Poatsy, Mulbery, Hulett, Krebs, & Mast, 2011). Storing multiple worksheets within one workbook helps organize related data together in one file and enables you to perform calculations among the worksheets within the workbook (Grauer, Poatsy, Mulbery, Hulett, Krebs, & Mast, 2011). Business typically uses Microsoft Excel to store simple information. ...
Words: 691 - Pages: 3
...Efficiency and Collaboration Proposal | | BIS220 September 4, 2012 As our company, Party Plates, continues to grow and expand, we must consider other viable options to improve our information systems. Our sales department’s database has basically outgrown Excel and we need to commit to switching over to Access. In the long run, we will save time by having the program filter our queries, by tracking personnel data and storing pertinent information for the sales department. In order for us to achieve greater success, we need to explore the technologies that are available to us that will enable us to improve internal communications and develop ways to streamline certain actions in the sales department. It was originally a good idea for Party Plates to use Microsoft Excel for data storage; however, the massive amount of data the company currently produces necessitates a relational data structure like Microsoft Access. Access allows users to divide information into logical fragments, and place each piece in a separate table. This structure will make it easier to manage data, avoid trouble with data redundancy, and improve employee efficiency. Party Plates can also use Access to create data entry forms that will expedite the data entry process and reduce the risk of employees entering data in the wrong table (Microsoft, 2012). The ways Access will benefit and improve sales improve communications and streamline work is by being able to bring up a specific search of a certain...
Words: 521 - Pages: 3
...primary care by collaborating with FQHC. Analysis of Key Issues: The key issues in the article address the challenge to increase efficiency, improve integration of services, and a quality-based payment system in healthcare systems that is presented by the Affordable Care Act (ACA).1 With the new healthcare legislation of the reform, an $11 billion is supplied for community health centers that are managed as FQHCs for Medicare purposes. This budget increase provides opportunity and necessary resources to expand FQHC systems to local communities. The article focuses on expansion through a collaboration agreement of physician integration while discussing the differences between FQHC and provider-based Medicare programs, the benefits to health systems from FQHC collaboration, as well as benefits to FQHCs from health system collaboration. Most important of these differences between FQHC and provider-based programs include FQHC benefits that are not available to provider-based programs, including higher reimbursements; malpractice cost savings; patient drug coverage; and eligibility to receive additional grants from private federal, and state sources. The discussion of benefits for both FQHC and provider-based programs indicate that reimbursement methods can improve efficiency while limiting costs and expenditures from the help of the collaboration effort, while also providing administrative support of FQHC, who...
Words: 612 - Pages: 3
...Creative collaboration is one of the types of collaboration that proposes to make and create something.it is objective situated and has a characterized group that is in charge for delivering that item. The target for this kind of collaboration is to have the capacity to accomplish what an individual cannot produce on their own, either on the field which requires a lot of work to be accomplished by a single individual, or it requires different skills to accomplish. This type of collaboration focuses heavily on the outcome that a team can achieve together and its results are based on total efficiency. The result is needed with complete precision, it must also be a cost-efficient conclusion and with the most conceivable quality in which collaboration...
Words: 2049 - Pages: 9
...INTRODUCTION Partnerships are defined by the Audit Commission (1998) as “joint working arrangements where parties are otherwise independent bodies who agree to co-operate to achieve common goals, create a new organisational structure or process to achieve these goals, plan and implement a joint programme and share relevant information, tasks and rewards”. Stern and Green (2005) clarify the definition of partnerships further as programmes that have “a high level of commitment, mutual trust, equal ownership and the achievement of a common goal, as distinct from networks which involve sharing information or other resources but not for the explicit purpose of joint working”. Definitions are particularly significant to the topic of this essay, as the component characteristics of partnerships as set out above are often overlooked by organisations and individuals when approaching the delivery of activities ‘in partnership’. In theory, partnership involves collaborative working where people pool ideas and expertise, so the leadership, energy and services produced are greater than the sum of their individual capabilities. It also requires re-thinking the remit or boundaries of organisations within which leadership is to be distributed and respected. This is particularly relevant when considering partnerships to deliver single outcome agreements that have previously been the responsibility of one body, or several bodies in isolation. These are challenges to which public sector...
Words: 3261 - Pages: 14
