Preview

Microsoft Access and Excel:

Good Essays
Open Document
Open Document
788 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Microsoft Access and Excel:
Microsoft Access and Excel: How They Are Different and How They Are Applied In the Business World.

Both Microsoft Access and Microsoft Excel are programs created by Microsoft Corporation as a part of Microsoft Office. Though these two programs are quite similar, they are different in some ways simply because each of them is more efficient at solving certain important tasks. In order for a decision to make the best decision in obtaining maximum efficiency, performance and accuracy when drawing a conclusion as to what software is best for his/her organization, it is necessary for him/her to determine as to which of Microsoft Access or Microsoft Excel best works with the data used in his organization or environment. By expressing their functions using hypothetical scenarios, I will analyze each software and explain their differences as well as which one is good for what company and tasks.
Microsoft Excel has many advantages to the business world. Since most businesses want efficiency and simplicity, Excel has a comprehensive wizard and help files to help with that mission. It is comparatively easy to learn. It’s very simple and user friendly interface makes it that much more appealing.

Since it works well with using small amounts of data and simple data/databases, naturally, just about every business student knows Excel good enough to solve most problems that may arrive throughout their college career in many diverse classes/organizations; whether the functions needed are that of math, charts, statistics, etc… (this makes it easier to obtain help/advise from colleagues.)
Although Excel is quite popular, there are also many disadvantages to the software. For instance, when you need to work with larger files, Excel is not the system to use, nor can it be used to create large databases. Access can though.
As mentioned, Microsoft Access is an excellent tool for creating relational databases of any size. Not only that, but it also integrates great with any other

You May Also Find These Documents Helpful

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

    9. (TCO 1) You should use Access rather than Excel to manage your data when you (Points : 4)…

    • 368 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    It206 Wk4 Scenarios

    • 918 Words
    • 4 Pages

    A business professional wants to use Microsoft® Excel® to organize data for the monthly expense report. He has never used Microsoft® Excel® and is inquiring about the functions that would support him with this task.…

    • 918 Words
    • 4 Pages
    Good Essays
  • Satisfactory Essays

    Situation 1: A business professional wants to use Microsoft®Excel® to organize data for the monthly expense report. He has never used Microsoft® Excel® and is inquiring about the functions that would support him with this task.…

    • 409 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    bis345345

    • 487 Words
    • 3 Pages

    10. (TCO 1) Which of the following statements would best describe when to use Access, NOT Excel?…

    • 487 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Although Microsoft Excel is an acceptable platform for business, there are disadvantages to the program. When developing Microsoft Excel into a file, depending on the size, program execution may…

    • 745 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    TASK 3

    • 329 Words
    • 1 Page

    Furthermore the benefits of using spreadsheet is that it enables mistake or typos to be instantly corrected and the entire worksheet is automatically updated with the correct answers. This makes spreadsheets to have a much reduced margin of error. Therefore, using…

    • 329 Words
    • 1 Page
    Satisfactory Essays
  • Satisfactory Essays

    Analyzing Data Checkpoint

    • 359 Words
    • 2 Pages

    The first step is to determine exactly what analyzes you want to perform and ensure that you gather all that is needed. Keep in mind to import into Access it has to be formatted properly as an excel document. The second step is to create a database. This can be done by opening Access and creating a blank database (file, new, blank database). You will be prompted to name the database and where you would like to save it. Step three is to edit and validate all data. Be sure to have a primary key and that all data is valid. If the data were imported without, identifying a primary key or the data is “dirty” or not valid these issues can be addressed by using the utility queries in Access. The fourth step is to connect data files. When multiple data files have been imported into tables, edited, and validated, you need to connect the tables by creating relationships. Typically, a relationship connects a primary key in one table to a regular field in another table. For example, the Customer Number in the Customers table (a primary key) can be connected to the Customer Number field in the Sales table. You also need to establish a relationship between the matching fields in original tables and their validating tables. In our example, you would establish a relationship between the Customer Type field in the Customers table and the Customer Type field in the Customer Types table. Repeat this step for all validating tables.…

    • 359 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Microsoft Excel is an electronic spreadsheet. It can be used in several ways for several tasks. Excel is used to manage, store and calculate different types of information. One of the uses for Excel would be keeping track of a company’s warehouse inventory.…

    • 816 Words
    • 3 Pages
    Good Essays
  • Better Essays

    In this paper the writer will seek to respond to the questions designated for both scenarios. This paper will list typical fields for each type of data. Provide an example of two relationships that you need to track. This paper will also answer the questions of: Do you need a database system? If not, can Excel® handle the data and the output? What are the advantages and disadvantages? Would you use a personal database or an enterprise database? Explain your answer. Would a decision support system (DSS) be helpful? Explain your answer.…

    • 1392 Words
    • 6 Pages
    Better Essays
  • Good Essays

    The purpose of this proposal is to show you why improving the efficiency of the current information systems that is being used in the sales department will benefit Party Plates. The sales department is currently using Microsoft Excel and would like to move to another relational database such as Microsoft Access. Team A will be addressing how converting from Excel to Access will help the company, and the advantages of using Access and the disadvantages of using Excel. Team A will also introduce collaborative software and how it is used and what it will do for the company. Team A will also explain how the change will affect the internal communication and how the company can benefit for the change of software.…

    • 828 Words
    • 4 Pages
    Good Essays
  • Satisfactory Essays

    Excel is a powerful spreadsheet program that allows users to organize data, complete calculations, graph data,…

    • 492 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    Cis515

    • 3200 Words
    • 13 Pages

    References: Carter, J. (n.d.). Database Design and Programming with Access, SQL, Visual Basic and ASP.…

    • 3200 Words
    • 13 Pages
    Powerful Essays

Related Topics