• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

Microsoft Excel vs. Microsoft Access

Extracts from this document...

Introduction

Microsoft Excel vs. Microsoft Access Introduction In this report I will look at the two most popular business data handling tools. I will look at both pros and cons of each piece of software and compare to see which has the best tools for processing information to support effective business decision-making. Microsoft Access Microsoft Access is part of the software package Microsoft Office. It is used for easily creating databases. Microsoft Access is one of the more simple database software available however It has all the features needed to create a successful working database which is updateable at any time. An Access database can be made very user friendly and easily accessible to anyone who might not have great computer knowledge. On the other hand the database can be hard to interpret into data if no special interface is created. The setback which comes with Access is that time needs to be spent to create a database which is in complete working order with no glitches. ...read more.

Middle

This easy to use spreadsheet can be effortlessly be used to find a number of pieces of data. This makes it ideal for businesses because it allows the management easy access to current tariffs and the current market prices. From this they can decide better and more popular choices for their own customers. Similarities Both Access and Excel are intended to work out different problems. But both have similar features which are able to do the same thing in their own way. Here are some examples of the similarities between the two: First of all both pieces of software are Microsoft, this means they have the same fonts, toolbars, functions and compatibility. This is ideal for a business if the company has both pieces of software because the staff will have a good idea how to use both because of the graphical and positional similarities. ...read more.

Conclusion

Access doesn't have this feature and can only do limited calculations. Conclusion Taking into account both of these pieces of software can be used to process information I will make a decision on which is best for business decision-making. Access has the capability of holding large amounts of data securely and clutter free. However Excel data can only be stored on the spreadsheet so all data is on view at one time; this can make the data hard to interpret. Access can single out data make finding certain information easy with its search functions whereas Excel has all the data on screen. Excel however easily produces effective business decision making with its graphical representation of data features. Like creating a pie chart to understand what percentages of stock are being sold for example. In my opinion Excel should be used to make business decision making due to the fact data can be easily understood through the chart and table features. ?? ?? ?? ?? James Fairhurst Unit 3 M2 Christine Horridge ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our International Baccalaureate Misc section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related International Baccalaureate Misc essays

  1. ITGS portfolio Privacy and security issues that arise when using Health Information Technology to ...

    Earlier this year, Google Health was launched, an online personalized health records service. Google Health is based on the principle that since it's the patient's medical record, the patient should control it, decide what should be in it, and who gets access to it.

  2. A comparison and analysis of the speed and efficiency between Microsofts Windows XP and ...

    After BootROM, 'boot.efi' is loaded which loads the operating system. This can be seen as the 'booting' screen. 7 The number of overall processes during startup in the Mac are much less compared to Windows XP. Hence, it can be predicted that this would have an effect on the speed of the respective operating systems accordingly.

  1. ITGS portfolio Loss of employment and privacy issues regarding the rise of online grocery ...

    Even better, small specialty stores such as delicatessens, wine shops and bakeries are offering more and more online options and may give you the opportunity to order groceries for delivery online. But how can you find these sites and services in your area?

  2. According to the standards within the Ln Yu, has the Confucian gentleman survived to ...

    Under the laws of Li and Jen one aims to become a Ch´┐Żn-Tzu, being in social relations on an ethical base driven by virtues alone that would thus, if all would be brought together, create peace. Now as aforementioned, they are they are the virtues that hold dominion over the

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work