...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 has been a remarkable system that has enabled us to develop proper skills needed for accurate inventory; however, Microsoft Access appears to be a better target. Microsoft Access is dedicated to the same aspects of Microsoft Excel. Access is recommended because it helps...
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
...tracking system and its ability to create a more efficient sales department. Internet and programmer based evaluations along with employee knowledge base of programs should provide a good data sets for both reviewed programs. The report finds that Microsoft Excel offers the employees easier input options that perform similar tasks as Microsoft Access. This allows ABC Sales to develop the most robust data sets for the lowest cost, with minimal additional training requirements to existing staff. It is clear that ABC Sales Department needs to choose Microsoft Excel. Problem Statement The ABC Sales Department has an organizational problem. ABC Sales Department does not keep a record of annual inventory renewal schedules for their special projects. The sales department needs to start to keep these records in order to properly plan future budgets, set realistic goals for employees to reach, and be able to forecast proper pricing for renewals. The sales director needs to implement an easy to use and cost affective tracker for the managers to use. The managers need to start tracking these items in order to increase revenue so that the ABC Company can be successful in the market. Overview of Alternatives The following two alternatives considered in this report meet the ABC Company requirements: Alternative A-Microsoft Excel Spreadsheets In order to understand and track the revenue and dates of prior existing orders, databases can be exported...
Words: 2025 - Pages: 9
...Abstract This plan details the components necessary to develop a low-cost inventory control system to replace a frustrating manual tracking and reordering process. The hardware and software needed to implement the system is detailed as well as the cost associated with creating it. Furthermore, administrative functions associated with operation and maintenance of the system is provided with high-level descriptions. Critical counts can be adjusted to meet business specific requirements for any product detailed in the database. The system works in a circular process, from purchase tracking to inventory monitoring to re-ordering and back around again. This design allows a simple and efficient method to produce and inventory control system with the flexibility to manage many product types and suppliers. We all interact with inventory control systems on a daily basis. Rather it is at your local grocery stores checkout line or products purchased from your favorite online retailer, inventory control systems are at the center of our supply and demand chain. These systems ensure when we place our orders for products that the in stock, on order and committed quantities are accurate and monitored. It’s very common for large companies to use these types of systems is also becoming more common for small businesses. The following plan presents a low-cost alternative to the manual processes currently used by a small clothing store. The systems capabilities allow frustrating task such as...
Words: 832 - Pages: 4
...What is Access? Simple databases store information in only one table. These simple databases are often called flat file databases, or just flat databases. More complex database programs, such as Access, store information in multiple related tables, thereby creating what are referred to as relational databases. If the information in a relational database is organized correctly, you can treat these multiple tables as a single storage area and pull information electronically from different tables in whatever order meets your needs. Tables are one of the types of database objects you work with in Access. Other types include forms, queries and reports. Of these object types, only tables are used to store information. The others are used to enter, manage, manipulate, analyze, retrieve, or display the information stored in tables—in other words, to make the information as accessible and therefore as useful as possible. Table – data storage, the actual location of data Forms – used to enter, to change or to delete data Queries Reports Starting Microsoft Access If you are using an IT Services machine, login as usual by entering your username and password. Then, to start up the program: 1. Open the Windows Start button and choose All Programs 2. Select Microsoft Office 2013 then Access 2013 Tip: If you right click on the Microsoft Access entry in the menu and choose Send To then Desktop (create shortcut) you’ll have an icon on the Desktop for future easy access. You can...
Words: 1697 - Pages: 7
...Transportation Command Firewall Modification Request System Student Name Individual Project IS316 - Systems Analysis and Design Professor: Erlan Burk Park University Fall II 2005 12 December 2005 Table of Contents System Description 2-3 Functional Description 4-5 Data Dictionary 6-7 Context Level Diagram and Child Diagram 8-9 System Input, Output Forms, and Interfaces 10-14 Testing, Maintenance and Auditing 15-16 System Description System Name US Transportation Command Firewall Modification Request System (FMRS) Type of System FMRS is a Management Information System using a Microsoft Access Database and front end application. The system provides an avenue for customers to request firewall modifications and for the firewall maintenance team (Operation Information Security – OIS) to validate, track, and process requests in systematic fashion. Key System Benefits * User friendly interface available to users at any time * Request tracking and history * Report generation of prior activity * Improved firewall manageability * Improved customer response time * Reduction in man hours spent duplicating and researching firewall maintenance efforts Existing System Currently there is no automated request or tracking system for firewall modifications and accountability. Requests are made via email to the OIS group email account and are processed from there. With the current...
Words: 2252 - Pages: 10
...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 work environment, with the use of it the communication between employees is clear and faster, the corporation now can use applications that help to create documents, or prevent the duplication of data. With the use of it the company can avoid errors that can cost money and legal problems to the corporation. It gives the ability to have a better and faster access documents and programs to...
Words: 859 - Pages: 4
...tracking system and its ability to create a more efficient sales department. Internet and programmer based evaluations along with employee knowledge base of programs should provide a good data sets for both reviewed programs. The report finds that Microsoft Excel offers the employees easier input options that perform similar tasks as Microsoft Access. This allows ABC Sales to develop the most robust data sets for the lowest cost, with minimal additional training requirements to existing staff. It is clear that ABC Sales Department needs to choose Microsoft Excel. Problem Statement The ABC Sales Department has an organizational problem. ABC Sales Department does not keep a record of annual inventory renewal schedules for their special projects. The sales department needs to start to keep these records in order to properly plan future budgets, set realistic goals for employees to reach, and be able to forecast proper pricing for renewals. The sales director needs to implement an easy to use and cost affective tracker for the managers to use. The managers need to start tracking these items in order to increase revenue so that the ABC Company can be successful in the market. Overview of Alternatives The following two alternatives considered in this report meet the ABC Company requirements: Alternative A-Microsoft Excel Spreadsheets In order to understand and track the revenue and dates of prior existing orders, databases can...
Words: 2026 - Pages: 9
...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 the benefits of moving personnel data for Party Plates from Microsoft ® Excel into Microsoft ® Access. Though there are many more reasons to utilize Access or other similar relational database software, we will focus on the personnel data management in particular. The data collected on...
Words: 807 - Pages: 4
...manufactures decorative paper plates and napkins. The company is undergoing so changes to the information systems that is currently used to more up-to-date technology. Some of the changes are being recommended for implantation to help ensure more accurate tracking and accounting of inventory and other information. With the improvements in technology, the more antiquated systems like Microsoft Excel can be replaced with Access Databases for more efficiency. Microsoft Access is considered to be a relational database. A relational database is a collection of data that is stored or organized in a set to tables that are predefined to certain constraints. The tables will relate to other tables within the database and the information can be reorganized in different manners ("Search Sql Server", n.d.). The data that is stored in access can be retrieved in different layouts which will help with efficiency of the company. Instead of referring to possible two or more Microsoft Excel spreadsheets to find the information required, queries in Access can be set up and modified quickly to retrieve the data needed. Access has features that are user friendly to help manage the data and retrieve user friendly reports. One feature is the radio buttons that can predefined to search within the data or determine how the data is displayed. Radio buttons can be used to define the views, one example is to have the selection where the user can opt to display a certain criteria or not to display the data...
Words: 492 - Pages: 2
...PROPOSAL Converting data currently held in Microsoft® Excel® spreadsheets into a rational database using Microsoft® Access® can be useful in creating reports. These reports can be run at any time by users. “With Office Access 2007, you can link tables to your database from other Access databases, Excel spreadsheets, Windows SharePoint Services sites, ODBC data sources, Microsoft SQL Server databases, and other data sources. You can then use these linked tables to easily create reports so you can base your decisions on a more comprehensive set of information” (Microsoft Office Access benefits). Access can be used by multiple users working on the data at the same time; even several users can work on the same data at the same time. Access locks in a record only while the user changes it; when users use Excel workbook it can be shared, but users should change data in Excel at separate times for the process to work best. “If you need to connect to several data sources and edit the data directly in those sources, then Access is your choice. You can view external data with Excel, but you can't change that data” (Office Microsoft). Wireless to IT uses The benefits of using Microsoft Access in the work place for the company would be one of the easier ways to create contacts, assets tracking, issue tracking, project tracking. With the program it would keep up with current customers, and their previous order. The company with and using this program can also share or forecast their sales and...
Words: 813 - Pages: 4
...Microsoft Office provides a plethora applications used for all aspects of business, schooling, and personal agendas. Some of the specific applications are Microsoft Word, Microsoft Excel, and Microsoft Access. One of the great advantages of having knowledge about these 3 applications in particular is the user’s ability to intertwine information amongst each program. Microsoft Word is a basic application to advanced users but may seem rather complex and overwhelming to a novice. This is the application of choice for preparing professional or personal written materials for choice audiences. Microsoft Word is not only capable of handling written materials it is also built to handle pictures, clip art, tables, and graphs. One main drawback of Microsoft Word is its ability to allow multiple users to edit its contents at the same time. Microsoft Excel is something that we are accustomed to using daily in this company. In fact, it was one of the prerequisites when we hired you and the rest of the staff. It is obvious that your capabilities with Microsoft Excel are endless and your contribution s thus far has not gone unnoticed. Our company is growing and we have to come up with new innovative alternatives to update and share information. As great as Microsoft Excel can be it has weaknesses that leave us vulnerable to our own ambitions. Using Microsoft Excel as our stable for tracking sales and products prevents multiple users from updating similar categories at the same...
Words: 372 - Pages: 2
...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, meaning it is free (“PostgreSQL”, 1996-2012)., MySQL is also an open source database that runs on multiple operating systems ("Advantages And Disadvantages To Using Mysql Vs Ms Sql", n.d.)., MSSQL is a closed, propriety database that works great with Microsoft programs ("Advantages And Disadvantages To Using Mysql Vs Ms Sql", n.d.)., and Fire Bird which works well with Window and is also...
Words: 1026 - Pages: 5
...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 3 Simple Getaways business improvement proposal Throughout the years Simple Getaways has increased their number of stores throughout the western United States and they have had some growing pains in that process. Most of these growing pains are associated with administrative tasks but can be very destructive if not fixed or corrected before producing a downhill rolling...
Words: 1908 - Pages: 8
...Using Microsoft Access Getting Started Using Microsoft Access Microsoft Access is a computer application used to create and work with databases. In computer jargon that means it’s a Database Management System or DBMS. So what is a database? A database is basically a collection of data or pieces of information. Whether you know it or not, you use databases all of the time. Some examples of commonly used databases might be: • • • • Address book Library catalogue Telephone directory Stock list A database isn’t necessarily contained on a computer. A telephone directory is still a database even if it’s in the form of a huge book sitting next to your phone. However, for the purpose of these exercises, we will assume that the term database refers to an organised collection of information stored on a computer. Databases are intended for storing and maintaining large amounts of information. The following are examples of the sort of information that can be kept in a database: • • • • • Inventory control Payroll systems Personnel records Music collection catalogue Phone and address lists In the exercises that will follow you will create a simple database while you learn the basic features of Access. Later on, you will create a more complex database as you learn more advanced features in addition to some of the principles of database theory. In these exercises it is assumed that you are familiar with Windows use and have experience in using other applications such as Word or...
Words: 4436 - Pages: 18
