• 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 Loss of employment and privacy issues regarding the rise of online grocery ...

    Basic Tips When browsing through virtual shopping aisles, be sure to use: * A secure password. When setting up an account at an online store, don't pick everyday words, family member names, or birthdates. Instead, use combinations of uppercase and lowercase letters, numbers, and symbols.

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

    EMRs are not that efficient. Despite efforts in digitalization and standardization, EMRs are actually far from being standardized and not as efficient as it is purported to be. It often happens that one clinic's EMR system is not compatible with that of a general practitioner or another clinic's system, thus belying the claim of added efficiency.

  1. Comparing and Contrasting Envy and Deception in Shakespeares Much Ado About Nothing and Othello

    However, he still gives in to his delusions and even sees himself as her saviour. This is clear when he says to Desdemona, "I will not kill thy unprepar�d spirit/No - heaven forfend - I would not kill thy soul!"

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

    Ancient Men and Their Values As the metaphysical was being analyzed and commented on in the East, so was it in the West. The world-renowned Greek philosophers had also warped the thoughts of virtue; the philosophers in question being Plato, Aristotle, Alcinous, Plotinus and in a far hedonist realm, Epicurus.

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

    two big names in the market; two big corporations that have been competing for decades with each other. Mac OS X version 10.4 "Tiger" is the fifth major release of Mac OS X, Apple's desktop and server operating system for Macintosh computers.

  2. SALES OF GOOD ACT

    waives the condition : When a condition to a contract is not fulfilled & the buyer does not insists on the fulfillment of the same he is deemed to have waived the condition & therefore will not be allowed to repudiate the contract afterwards for the non-fulfillment of the condition.

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