Efficiency and Collaboration Proposal

In: Computers and Technology

Submitted By ccwade02
Words 527
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 a query based on the Product table. Access also provides two utilities to help protect the data within a database: Compact and Repair and backup. These two functions both help protect our data, Compact and repair reduces the size of the database. Backup creates a duplicate copy of the database. Access provides us with many tools that we can use to identify and extract only the data needed at…...

Similar Documents

Bis220 Efficiency and Collaboration Proposal

...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

...Efficiency: 1. More flexible compensation tools to simplify administration and less effort to adapt to the current rigid system. 2. Clarifying how employees are compensated and linking compensation to job performance should improve organizational performance and efficiency. 3. Formal compensation analyst infrastructure will provide more efficient determination of market-based compensation Flexibility and Responsiveness: 4. Linking employee pay to the marketplace will make the system more responsive to business need. 5. Flexible compensation tools will allow us to more accurately meet the business need. 6. A new system should be flexible enough to adjust as business needs change. Alignment: 7. Flexible compensation tools to support recruitment of needed staff. 8. Compensation linked to employee performance to encourage employee participation and employee development over the employee lifecycle. 9. Compensation that recognizes employees based upon the marketplace for their current competence which should also encourage staff to develop skills to advance their compensation and at the same time benefit the organization. 10. Compensation analyst infrastructure will assist in aligning compensation structure with other universities and/or private sector as applicable for the university to remain competitive for talent. Consistency: 11. The compensation system tools should be available across employee categories. The particular compensation system...

Words: 613 - Pages: 3

Efficiency and Collaboration Proposal

...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......

Words: 307 - Pages: 2

Efficiency and Collaboration Proposal

...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...

Words: 527 - Pages: 3

Efficiency and Collaboration

...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...

Words: 720 - Pages: 3

Efficiency and Collaboration Proposal

...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...

Words: 754 - Pages: 4

Efficiency and Collaboration Proposal

...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...

Words: 684 - Pages: 3

Efficiency and Collaboration

...Efficiency and Collaboration Alicia Mercier, Kathy Bowie, Angelia Moncrief-Wells, Beverly Yharbrough BIS/220 October 31, 2013 Frederick Lumpkin Efficiency and Collaboration The purpose of this proposal is to show the potential implementation of new information systems at Party Plates. There is so much excitement that comes with introducing all the new changes that could take place. The sales department is currently using Microsoft Excel but after looking around for something that would suit the businesses needs better it was found that Microsoft Access can fill those needs. As technology and our business grows there are always ways to improve. There are many benefits to switching over to Access that will benefit the company that will be discussed. Suggestions will be debated for future use of collaborative software and how it can help the sales department and how it can improve communications. Computers are very useful in today’s world. When you’re dealing with Microsoft excel, there’s a lot of information that you can create in Microsoft excel. Trying to convert data into Microsoft excel spreadsheet using Microsoft, is not an easy task. Excel can hold more information and it is generally very easy to read. Excel is a flat file database, not a relational database (Microsoft.com, 2013). Excel is very useful because you can analyze information or data, graphs, calculations, formulas, copy, paste and you can use it as a word document. You can decorate the...

Words: 819 - Pages: 4

Efficiency and Collaboration

...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...

Words: 859 - Pages: 4

Bis 220 Week 3 Efficiency and Collaboration Proposal

...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...

Words: 521 - Pages: 3

Efficiency and Collaboration Proposal

...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...

Words: 387 - Pages: 2

Efficiency and Collaboration Proposal

...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...

Words: 701 - Pages: 3

Efficiency & Collaboration Proposal

...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...

Words: 612 - Pages: 3

Efficiency & Collaboration Proposal

...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...

Words: 415 - Pages: 2

Bis 220 Week 3 Learning Team Efficiency and Collaboration Proposal

...BIS 220 Week 3 Learning Team Efficiency and Collaboration Proposal To Buy This material Click below link http://www.uoptutors.com/BIS-220/BIS-220-Week-3-Learning-Team-Efficiency-and-Collaboration-Proposal Resources: Ch. 1 & 2 of Excel® in Microsoft® Office 2010. Scenario: Imagine you are an employee of Party Plates, a company that manufactures decorative paper plates and napkins for special events. Your team has been assigned a new project. The president of your company has tasked you with improving the efficiency of the current information systems used in the sales department, because the current systems are somewhat antiquated. Your organization is currently using Microsoft® Excel® to track all personnel data, but would like to migrate to a relational database like Microsoft® Access®. You have also been tasked with identifying potential collaborative software that may improve internal communications and help streamline some of the work processes for the sales department. Prepare a 1200- to 1500 word proposal addressing the potential implementation of new information systems in your organization. Note: The Cover Page and Reference Page does not count towards the word count. Explain the usefulness of converting data currently held in Microsoft® Excel®spreadsheets into a relational database using Microsoft® Access®. Describe the benefits of using Microsoft® Access® in the work environment. Include suggestions for the future use of collaborative software and......

Words: 253 - Pages: 2