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

    digitized for almost just anybody to see - in other words, incursion into people's privacy. The confidentiality of doctor - patient relationship is still sacrosanct. Besides, medical data can be used against a person in some cases - be it for a job application, insurance coverage or a college scholarship.

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

    If you lived in a small town with just one bookstore and they didn't stock the novel you wanted, the Internet was a solution. The big sellers were "hard goods," those things you didn't have to touch, feel or smell in order to buy, such as books, computers and other electronics.

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

    to what is contrary to propriety; make no movement which is contrary to propriety." Yen Yuan then said, "Though I am deficient in intelligence and vigor, I will make it my business to practice this lesson." (Velasquez, 2005) With those, the gentleman is seen as said, a man-of-manness, living bounded

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

    Combining the two, I decided to compare and analyze the commonly used features to determine which aspect is best for which kind of users. The two operating systems were readily available at my school, hence they became a choice for my investigation.

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