180 likes | 263 Views
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.
E N D
When deciding which program to use, consider: The type of data you are managing • What you want to do with that data
Excel works very well when: Performing sophisticated calculations • Analyzing complex numerical data • Customizing charts • Creating What-If scenarios
What If. . . You want to determine a purchase price for a home with a monthly payment of $450.00?
Access works better than Excel when… Managing repeated data • Entering large amounts of data • Generating detailed reports
Access can handle this problem if you break apart different data sets into logical pieces and place them into separate tables
Separate Data into Tables Sales Reps Customers
Customized forms in Access enable users to enter data easily and accurately
Related Data Can be Pulled from Multiple Tables One Sales Rep Has Many Customers
Reporting capabilities in Access make it very quick and easy to generate sophisticated reports from tables or queries