Analyses and numbers? Choose Excel.
So where does Excel shine? With numbers! You can run sophisticated what-if models and cost-benefit analyses that you can't in Access.
Do you need PivotTable reports? These are interactive tables that allow you to rotate rows and columns and see different summaries of your data. Excel makes it easier to work with PivotTable reports and PivotChart reports — charts based on those tables.
Do you want to convey information visually, by using charts or data bars? Excel is your tool.
Finally, not everyone has Access, and not everyone knows how to use it. Your coworkers may prefer Excel.
Those are just a few of the reasons for using Access or Excel. The links in the Quick Reference Card at the end of this course take you to more information about using each program.