...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
...Napkins Company Table of Contents Introduction 3 Benefits of Implementing Microsoft Access 3 Sales and Collaborative Software 4 Table……………………………………………………………………………………………....5 Conclusion 5 References...………………………………………………………………………………….……6 Proposal: Implementation of Microsoft Access Database Introduction Our party plates manufacturing business is growing and our customer base numbers are increasing every month therefore I am writing this proposal to implement a “Relational Database Management system”. The system we are proposing is Microsoft Access. The reason we are proposing to implement this new system is because since our business is growing it is getting cumbersome and time consuming to manage multiple “Excel” files to analyze company’s data. According to article by CPA Janet Samuels and Robert wood they suggest “Data handling and reporting capabilities of access are more efficient” (Samuels, Woods 2007). Excel should be used when we need to create a onetime report by plugging in data, however in access you will have to setup a database to form reports. Therefore, we should implement the relational database so information is forever stored and accessible by employees to create different multiple reports. The benefits of implementing Microsoft Access over Excel are listed below. Benefits of Implementing Microsoft Access 1. We can easily import all of our Excel files in to access by using the External data ribbon. This imported data will be saved as one of...
Words: 831 - Pages: 4
...Running head: BUSINESS IMPROVEMENT PROPOSAL 1 Simple Getaways business improvement proposal BUSINESS IMPROVEMENT PROPOSAL 2 Abstract In recent years, Simple Getaways has increased locations throughout western United States to give more customers the opportunity to travel to their desired locations. While expanding, the company has faced some challenging obstacles on their way which affect the company, the stakeholders and the customers. In this paper I will discuss the challenges to the stakeholders, the performance of Simple Getaways and discuss a solution for the company that benefits everyone involved so the company succeeds going forward. The obstacles the company faces is mainly administrative tasks by having multiple versions of documents at multiple locations as well has other locations not being able to get forms without emailing them and faxing them. The implementation of Microsoft Sharepoint and Office 365 you will see how they can change the processes and eliminate the challenges the company has with the administrative task and multiple versions of documents. BUSINESS IMPROVEMENT PROPOSAL ...
Words: 1908 - Pages: 8
...Efficiency and collaboration proposal Benefits of using Microsoft Access Microsoft Access is a database application included in Microsoft Office, which helps businesses to save money. The different components and features make Microsoft access easy to use. The database application is beneficial to the work environment and offers a quick-learning format (Demand Media, Inc., 1999-2012). People can create an operational database in less than one-hour when importing information from other Microsoft Office applications (Demand Media, Inc., 1999-2012).Microsoft Access is capable of taking information from the enterprise software. More than one person can access or use the database at a time. People can add, delete, and update information instantly without the knowledge of programming languages (Demand Media, Inc., 1999-2012). Beginners can use the database wizard to create database objects and relationships that has easy to follow instructions. The database application helps to avoid errors and duplicates of data. The application is compatible with word and excel. There is no database code needed to perform database functions where with other applications a code is required. Microsoft Access has predesigned database templates allowing people to add data immediately without developing a template (Demand Media, Inc., 1999-2012). A business would benefit from Microsoft Access because most businesses grow and collect data over the years. The business can use the application to...
Words: 267 - Pages: 2
...K@W Record Store Inc… Table of Contents …………………………………………………………………………… #1 Introduction …………………………………………………………………………………... #2 Benefits of Implementing Microsoft Access to New Record Inventory………………………. #3 Sales and Collaborative Software ………………………………………………………………#4 Table…………………………………………………………………………………………....#5 Conclusion……………………………………………………………………………………..# 6 References...………………………………………………………………………………….…#7 Proposal: Benefits of Implementing Microsoft Access to New Record Inventory Introductions: Here at K@WRECORD stores, we strive to provide consumers with the latest in hi-tech and cutting edge service at all times. K@WRECORD stores must keep up with the technology of our times to stay competitive in the music industry. Therefore, K@WRECORD stores, is planning on taking its retail methods to a new level. Due to the recent high traffic and growing demand, I, Kaitlin Williams (Microsoft Analyst), am writing this proposal to implement a “Relational Database Management system”. The system we are proposing is Microsoft Access. The reason we are proposing to implement this new system is because, as you all my now times are changing and keeping data is not quite like it was when records first came out. The first form of “records,” or albums, were large vinyl records that took up a large amount of space and were worth much more in their time than they, or any other form from tapes to CDs, are worth today. The reason we are proposing to implement this new system is because...
Words: 271 - Pages: 2
...Business Proposal Sheldon Hensley BIS/220 March 19, 2012 Ross Sines Business Proposal Rock Bottom Records A Business Proposal to Add E-Commerce to the Company Prepared for Rock Bottom Records Prepared by Sheldon Hensley March 19, 2012 Table of Contents Executive Summary 4 Introduction 5 Background 5 Proposed Action 5 Cost Table 8 Executive Summary Doing business in today’s economic structure is not the same as it was 20 years ago. The induction of e-commerce and e-business to economic infrastructure, traditional brick and mortar businesses are finding it difficult to compete with more streamlined businesses that are outsourcing their products and services via the Internet. Streamlining Rock Bottom Records by adding a relational database management system (RDMS) and a website will increase productivity and cost savings by reducing the amount of time it takes for analyzing productivity, ordering and shipping, financial, and payroll. Adding a website with a RDMS and offering digital music downloads the company will be able to compete with other companies worldwide. The most popular affordable RDMS’s that are in use today are Microsoft Access that comes with Microsoft Office (Professional) is popular with most small businesses ("Microsoft Access Database: The Pros With Less Cons When Using Microsoft Access As Your Database", n.d.)., PostgreSQL which runs on multiple operating systems and is an open source database...
Words: 1026 - Pages: 5
...The intent of this proposal is to describe the effectiveness of switching from Microsoft® Excel to Microsoft ® Access and how internal communications will help modernize the sales department. Let me start by saying that Microsoft® Access is a user-friendly tool and is simple to learn. It provides for the easier adding, subtracting, and altering of data, in addition to offering the ability for more than one user to update tables at the same time. 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. Benefits delivered once data has been entered in Microsoft® Access: • We will also be able to use the reports to drive positive business results. • 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. Although 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. Access is the better solution for an extensive customer list. In our business of Party Plates there is a need to categorize certain information to create a database that will...
Words: 536 - 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 James M. McCarver, Jill Brogan, Judy Vilayphone, Lashunda Wallace, Laura Silberman, Mem Sanders BIS 220 May 13, 2013 Lars Vesterberg Efficiency and Collaboration Proposal The purpose of this proposal is to show you the potential implementation of new information systems at Party Plates. We are excited to introduce all the new changes taking place. The sales department is currently using Microsoft Excel but after looking around for something that would suit our needs better we found Microsoft Access. As technology and our business grow we are always looking for ways to improve. We will tell you how switching over to Access will benefit the company. We will also include suggestions for future use of collaborative software and how it can help the sales department improve communications. Stated below are the changes being made. Microsoft Access is a program that is used to store large data. Microsoft Access is very beneficial in the work environment, because of the different features that it offers, and it is easy to learn. The program is user friendly which incorporates other features offered through Microsoft Office. Without sacrificing performance, large amounts of data can be stored into the database. It is very easy to store available information into the database. If your office environment is large , Access may be programmed to retrieve information from the enterprise software. This short document will illustrate...
Words: 807 - Pages: 4
...Efficiency and Collaboration Proposal BIS/220 October 19, 2011 Efficiency and Collaboration Proposal Party Plates has grown significantly within the last two years and the current Excel system, excel, cannot keep up with all data. In order to improve the efficiency of the current information systems used in Party Plates, the antiquated system needs to be upgraded to a much more efficient system such as Microsoft Access. The upgrade will benefit the company in terms of better data tracking and the ability of producingto produce useful reports in relation to customer sales. Microsoft Access is a database software that allows a user to manipulate large amounts of data. Unlike Excel, Access can hold more than 65 thousand records, which can be converted and viewed in various forms depending on what is needed. Microsoft Access offers two main benefits, its user friendly friendliness and its ability to hold large amounts of data without sacrificing performance. Microsoft Access functions in different ways that tie together …what? . Tables are used to store data from which queries can pull information from and perform calculations against the data. Forms can be used to enter information into tables. Reports will allow the information to be displayed in a printer-ready format. The reports can also be exported to other Microsoft Office programs, such as Excel or Word. Finally, macros allow for the automation of database tasks. Modules are an area for advanced...
Words: 1402 - Pages: 6
...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
...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
...Managed private investment portfolios of 40 investors valued at more than $50,000 each • Initiated, coordinated, and presented proposals of services and capabilities via PowerPoint presentations to prospective clients; increased clientele by 20% Generated quarterly and annual financial statements on partnerships and direct investments using Excel • • Conducted extensive financial and compliance audits of institutional operations with team members PAINE WEBBER, Arlington, Virginia System Administration Intern, January 2011 – May 2011 • Maintained and supported the financial reporting tools using MS Access • Compiled and analyzed the quarterly financial statements of investee partnerships and direct investments • Administered a comprehensive Access database with more than several thousand company investments used by compliance and trading departments GOODENOUGH CO, LTD., Taipei, Taiwan Accountant and Sales Assistant, December 2008 – July 2010 • Maintained accounting records for an international trading company to ensure accurate records • Visited customers on site and negotiated products prices with customers • E-mailed customers on behalf of supervisor to address inquires regarding product description and price COMPUTER SKILLS Desktop Applications: Microsoft Excel, Word, PowerPoint and Publisher Statistical Software: E-views, SAS Database: Oracle, Microsoft Access, Lotus Approach Operating Systems: Windows NT, XP, Novell Netware, DOS, UNIX, and Linux ACTIVITIES Treasurer, Financial...
Words: 359 - Pages: 2
...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
...DeVry University Keller Graduate School of Management Creating a Database for Storing and Managing Church Members’ Record for R.C.C.G. Heaven’s Gate Gbolade O. Soneyin gsoneyin@my.keller.edu (770) 598-5006 MIS-535-18371 Managerial Applications of Information Technology Professor Tanya Cannon Thursday, February 12, 2015 Table of Contents Subject of Course Project 3 Business Problem Stated 3 Name of the Organization 3 Proposed Solution 3 General Benefits 4 Audience 4 References 5 Abstract To help Heaven’s Gate move away from tracking its members on spreadsheets and paper, move to a database application that will not only track members, but also track department activities, members contributions, and do it all via the least economically, but yet effective, easily accessible and requiring limited technical or IT expertise to maintain. Keywords: RCCG, Database, Church, Heaven’s Gate, Application, Church Management Company Background Heaven’s Gate is one of many parishes of the Redeemed Christian Church of God (RCCG), headquartered in Lagos, Nigeria; finding out exactly how many parishes of the church existed was next to impossible. In her well-detailed article on the church, Olufunke Adeboye wrote about the church from 1952-2005. Founded by Josiah Olufemi Akindayomi in 1952, after receiving vision to write down the church’s name on a wooden board, this despite the fact the man was unschooled at the time; he cannot read nor know how to write. After writing...
Words: 1607 - Pages: 7
