Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Access versus Excel
- Thread starter wriggley
- Start date
I use version 2000 of both Excel and Access extensively. Here are my 2 cents...
Excel is excellent for statistics and calculations as well as data manipulation. It creates great charts and graphs and has an excellent tool called PivotTables for data analysis. But is weak in the database arena.
Access is not only a great database for small data storage needs, but also great for creating sophisticated reports.
I use Excel to work with text data that involves thousands of records. But I glean off the essential data and input into Access for better reports.
Now Excel is great when creating reports for the web. Access needs a little more work in that arena. But the Data Access Pages in version 2000 is a great tool if the volume of data is not too large. I found having data larger than 10000 seems to make it bog down a bit. Then again, I'm trying to create pivottables that are usable on the web.
It all depends on what your needs are. If data manipulation/analysis and calculation is required, Excel. If generating sophisticated reports is necessary, Access.
Does that help??
Mary
)
Excel is excellent for statistics and calculations as well as data manipulation. It creates great charts and graphs and has an excellent tool called PivotTables for data analysis. But is weak in the database arena.
Access is not only a great database for small data storage needs, but also great for creating sophisticated reports.
I use Excel to work with text data that involves thousands of records. But I glean off the essential data and input into Access for better reports.
Now Excel is great when creating reports for the web. Access needs a little more work in that arena. But the Data Access Pages in version 2000 is a great tool if the volume of data is not too large. I found having data larger than 10000 seems to make it bog down a bit. Then again, I'm trying to create pivottables that are usable on the web.
It all depends on what your needs are. If data manipulation/analysis and calculation is required, Excel. If generating sophisticated reports is necessary, Access.
Does that help??
Mary
)- Status
Similar threads
- Locked
- Question
- Question