1 / 18

Excel vs. Access: Choosing the Right Data Management Tool

Learn the differences between Excel and Access for managing data. Excel is great for calculations, charts, and analyses, while Access excels in handling repeated data and generating detailed reports. Discover which program suits your data needs best.

orea
Télécharger la présentation

Excel vs. Access: Choosing the Right Data Management Tool

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Should you choose Excel or Access to manage your data?

  2. When deciding which program to use, consider: The type of data you are managing • What you want to do with that data

  3. Excel Works Well with Flat File Data

  4. Excel works very well when: Performing sophisticated calculations • Analyzing complex numerical data • Customizing charts • Creating What-If scenarios

  5. What If. . . You want to determine a purchase price for a home with a monthly payment of $450.00?

  6. Excel Pivot Tables Summarize and Analyze Complex Data

  7. Excel Supports Many Types of Charts

  8. Access works better than Excel when… Managing repeated data • Entering large amounts of data • Generating detailed reports

  9. Avoid the Problem of Repeated Data

  10. Access can handle this problem if you break apart different data sets into logical pieces and place them into separate tables

  11. Separate Data into Tables Sales Reps Customers

  12. Multiple Tables can be Related by a Common Field

  13. Customized forms in Access enable users to enter data easily and accurately

  14. Related Data Can be Pulled from Multiple Tables One Sales Rep Has Many Customers

  15. Reporting capabilities in Access make it very quick and easy to generate sophisticated reports from tables or queries

  16. Compare Benefits of Both Excel and Access

  17. http://ittraining.iu.edu

More Related