should you choose excel or access to manage your data?
DESCRIPTION
Should you choose Excel or Access to manage your data?. When deciding which program to use, consider:. The type of data you are managing. W hat you want to do with that data . Excel Works Well with Flat File Data. Excel works very well when :. Performing sophisticated calculations. - PowerPoint PPT PresentationTRANSCRIPT
![Page 1: Should you choose Excel or Access to manage your data?](https://reader036.vdocuments.us/reader036/viewer/2022062521/56816900550346895de0111a/html5/thumbnails/1.jpg)
Should you choose Excel or Access to manage your data?
![Page 2: Should you choose Excel or Access to manage your data?](https://reader036.vdocuments.us/reader036/viewer/2022062521/56816900550346895de0111a/html5/thumbnails/2.jpg)
• The type of data you are managing
• What you want to do with that data
When deciding which program to use, consider:
![Page 3: Should you choose Excel or Access to manage your data?](https://reader036.vdocuments.us/reader036/viewer/2022062521/56816900550346895de0111a/html5/thumbnails/3.jpg)
Excel Works Well with Flat File Data
![Page 4: Should you choose Excel or Access to manage your data?](https://reader036.vdocuments.us/reader036/viewer/2022062521/56816900550346895de0111a/html5/thumbnails/4.jpg)
• Performing sophisticated calculations
• Analyzing complex numerical data
Excel works very well when:
• Creating What-If scenarios
• Customizing charts
![Page 5: Should you choose Excel or Access to manage your data?](https://reader036.vdocuments.us/reader036/viewer/2022062521/56816900550346895de0111a/html5/thumbnails/5.jpg)
What If. . .You want to determine a purchase price for a home with a monthly payment of $450.00?
![Page 6: Should you choose Excel or Access to manage your data?](https://reader036.vdocuments.us/reader036/viewer/2022062521/56816900550346895de0111a/html5/thumbnails/6.jpg)
Excel Pivot Tables Summarize and Analyze Complex Data
![Page 7: Should you choose Excel or Access to manage your data?](https://reader036.vdocuments.us/reader036/viewer/2022062521/56816900550346895de0111a/html5/thumbnails/7.jpg)
Excel Supports Many Types of Charts
![Page 8: Should you choose Excel or Access to manage your data?](https://reader036.vdocuments.us/reader036/viewer/2022062521/56816900550346895de0111a/html5/thumbnails/8.jpg)
• Managing repeated data
• Entering large amounts of data
Access works better than Excel when…
• Generating detailed reports
![Page 9: Should you choose Excel or Access to manage your data?](https://reader036.vdocuments.us/reader036/viewer/2022062521/56816900550346895de0111a/html5/thumbnails/9.jpg)
Avoid the Problem of Repeated Data
![Page 10: Should you choose Excel or Access to manage your data?](https://reader036.vdocuments.us/reader036/viewer/2022062521/56816900550346895de0111a/html5/thumbnails/10.jpg)
Access can handle this problem if you break apart different data sets into logical pieces and place them into separate tables
![Page 11: Should you choose Excel or Access to manage your data?](https://reader036.vdocuments.us/reader036/viewer/2022062521/56816900550346895de0111a/html5/thumbnails/11.jpg)
Separate Data into Tables
Sales Reps
Customers
![Page 12: Should you choose Excel or Access to manage your data?](https://reader036.vdocuments.us/reader036/viewer/2022062521/56816900550346895de0111a/html5/thumbnails/12.jpg)
Multiple Tables can be Related by a Common Field
Sales Reps• RepID• Name• Address• City• State• Zip• DateHired• District
Customers• CustID• Name• Address• City• State• Zip• RepID
Orders• InvNumber• OrderDate• ShippingDate• CustID• TotalSales
![Page 13: Should you choose Excel or Access to manage your data?](https://reader036.vdocuments.us/reader036/viewer/2022062521/56816900550346895de0111a/html5/thumbnails/13.jpg)
Customized forms in Access enable users to enter data easily and accurately
![Page 14: Should you choose Excel or Access to manage your data?](https://reader036.vdocuments.us/reader036/viewer/2022062521/56816900550346895de0111a/html5/thumbnails/14.jpg)
Related Data Can be Pulled from Multiple Tables
One Sales Rep
Has Many Customers
![Page 15: Should you choose Excel or Access to manage your data?](https://reader036.vdocuments.us/reader036/viewer/2022062521/56816900550346895de0111a/html5/thumbnails/15.jpg)
Reporting capabilities in Access make it very quick and easy to generate sophisticated reports from tables or queries
![Page 16: Should you choose Excel or Access to manage your data?](https://reader036.vdocuments.us/reader036/viewer/2022062521/56816900550346895de0111a/html5/thumbnails/16.jpg)
![Page 17: Should you choose Excel or Access to manage your data?](https://reader036.vdocuments.us/reader036/viewer/2022062521/56816900550346895de0111a/html5/thumbnails/17.jpg)
Use Excel for: Use Access for:
Flat file data Relational or repeated data
Calculations and analysis of numerical data Data entry for large data sets
Customized charts Relational forms
What-if scenarios Detailed relational reports
Compare Benefits of Both Excel and Access
![Page 18: Should you choose Excel or Access to manage your data?](https://reader036.vdocuments.us/reader036/viewer/2022062521/56816900550346895de0111a/html5/thumbnails/18.jpg)
http://ittraining.iu.edu