Preview

Microsoft Access Proposal Paper

Good Essays
Open Document
Open Document
617 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Microsoft Access Proposal Paper
Proposal for Microsoft Access
Team C
BIS/220
April 3, 2013
David Chandler

Party Plates Company has been growing consistently for the past few years. The increase in sales volume and customers has everyone in the corporate office struggling to maintain current customer information, sales trends, and customer orders. Our system of tracking all this data has been the use of Microsoft Excel. Although it is a vast program, and it has worked effectively for the company for many years; it is now time to implement a better and easier system that will allow everyone to have current and accurate information on the operations of the company. It will also increase the communication flow between our staff and corporate partners. We are therefore, proposing the implementation of Microsoft Access. Microsoft Access is a software that is used for relational data. Relational data structure helps divide data in relational pieces. With the
…show more content…
We will be able to run reports accurately, and at any time. Access allows multiple users to work on the same data at the same time. With Excel we could not change the information as easily, and we had to assign the job to one person at a time. That is time consuming and time is money. In addition, we consistently have the need to connect to several data sources at one time, and with Access we will be able to do so and change information or update information as we need to with a lower risk of making errors. This is going to make a huge impact on our sales as we will be able to keep up with our customer orders, check our sales trends, and follow up with any complaints or mistakes that have been made, in a timely manner. We will be able to communicate better as a team, and distribute the work evenly because the information will be broken down by departments. This will save us time and money and will help us better understand our business and improve the moral of the

You May Also Find These Documents Helpful

  • Good Essays

    First our team will talk about how Microsoft Access was used to create these tables by Huffman Trucking Database. Then how we used the tables with made up information to be tested on. Then on how we used forms in the maintenance database system. While the creation of relationships and normalization is explained in the process of using queries to search the database (University of Phoenix, 2007).…

    • 820 Words
    • 4 Pages
    Good Essays
  • Better Essays

    Microsoft Access Tutorial. (2005). Reports I: Show off your data. Retrieved on July 16, 2005 from http://office.microsoft.com/training/training.aspx?AssetID=RC010780631033.…

    • 2384 Words
    • 10 Pages
    Better Essays
  • Satisfactory Essays

    Review the ERD below to understand the entities, attributes, primary keys, and relationships that you will create in your Access database.…

    • 694 Words
    • 4 Pages
    Satisfactory Essays
  • Good Essays

    U42 P1

    • 574 Words
    • 3 Pages

    In this document I will be stating why your company should start to use Microsoft Excel for the business accounts instead of doing everything manually with the current pen and paper system.…

    • 574 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Using customized software developed from a variety of specialty software vendors, would reduce the error rate of misinterpreting data entries that should be handled differently due to the given business. Combining four departments onto one system will save time by having direct access to the records from all departments. This will reduce the amount of time required and will streamline activities. The documents will automatically be processed from each department and sent via the system to the necessary documents. The free-flow exchange of information back and forth will serve as one of the main advantages of the…

    • 804 Words
    • 4 Pages
    Good Essays
  • Good Essays

    Bis/220 Week 1

    • 1404 Words
    • 6 Pages

    Microsoft Access is designed as the ultimate software for your business needs. It does not allow you accept credit card or checks but the system has many other features like; Tracking the condition or status of assets or inventory, keeping track of your customers’ key information, buying habits, and frequent rewards. You also track other items like tracking the progress of team activities, manage events, donors, members, and donations for your company. Also, Keeping track of projects, tasks, and people assigned to them as the owner. You can easily download the templates if you feeling technology dim. You as a business owner have several options for different services, managing quotes, create invoices, and run your business all from this very database. Tracking inventory, create invoices, and establishing your price and keeping track of your competition. These features can also help your business run smoothly and hopefully without mechanical or computer error. In this system you can also create your own templates for employees or to add a certain vendor.…

    • 1404 Words
    • 6 Pages
    Good Essays
  • Satisfactory Essays

    Access provides the sales team with necessary information remotely and in a timely manner. A salesperson on the road can download the latest pricing information before an important meeting or appointment.…

    • 498 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    C) one value when the condition is true and another value when the condition is false…

    • 1829 Words
    • 8 Pages
    Good Essays
  • Good Essays

    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
  • Satisfactory Essays

    Is3110 Chapter 1

    • 789 Words
    • 4 Pages

    A data management system, such as Access, is software that allows you to use a computer to create a database.…

    • 789 Words
    • 4 Pages
    Satisfactory Essays
  • Satisfactory Essays

    MIS Spring2015 Syllabus 2

    • 2992 Words
    • 19 Pages

    New Perspectives on Microsoft Office ACCESS 2013, Comprehensive, ISBN-13: 978-1285099200. Authors: Joseph J. Adamski , Kathy T. Finnegan, Sharon Scollard.…

    • 2992 Words
    • 19 Pages
    Satisfactory Essays
  • Good Essays

    A United States Army common access card card is a Soldiers best friend, it keeps the Soldier and his Government secure, identified, protected from enemy threats. The common access card card is my only way past the gates each morning. The common access card card allows a Soldier access to several thousand pieces of classified information and training. The card also allows me to access innumerable benefits inside the Army, and limitless discounts inside and outside the Army. Also safe and effective navigation through army life with my special Department of Defense issued identification card. A common access card card has seemingly limited uses but its…

    • 10021 Words
    • 41 Pages
    Good Essays
  • Satisfactory Essays

    When doing research on how some of the main operations systems play a major role in the success of one’s business. Like Microsoft Words, one of the key tools when creating document needed for letters, resumes, and many other great things. Power Points are a good system when promoting your business, and Excel’s is a great expertise of organizing data, graph data, and to develop professional looking report.…

    • 492 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    flam

    • 1264 Words
    • 6 Pages

    Chris Zelinski started Green Scene Landscaping (GSL) five years ago, offering a wide range of lawn care services. In the early years of the business, Chris kept up with his customers, price quotes, service dates, and payment information using his memory and some paper-based records. As the business has grown, Chris has begun to realize that a better system for tracking customers is required. After considering several options, he has decided to replace his current system with an Excel workbook.…

    • 1264 Words
    • 6 Pages
    Powerful Essays
  • Satisfactory Essays

    access tutorial

    • 52738 Words
    • 211 Pages

    Microsoft-Access Tutorial Soren Lauesen E-mail: slauesen@itu.dk Version 2.4b: July 2011 Contents 1. The hotel system................................................... 4 2. Creating a database ............................................. 6 2.1 Create a database in Access ............................. 6 2.2 Create more tables ......................................... 10 2.3 Create relationships ....................................... 12 2.4 Look-up fields, enumeration type .................. 14 2.5 Dealing with trees and networks.................... 16 3. Access-based user interfaces ............................. 18 3.1 Forms and simple controls............................. 18 3.1.1 Text box, label and command button...... 18 3.1.2 Adjusting the controls............................. 20 3.1.3 Cleaning up the form .............................. 20 3.1.4 Shortcut keys for the user .......................…

    • 52738 Words
    • 211 Pages
    Satisfactory Essays