Or should you be using both? Access and Excel both feature data filtering, collation and querying, but which program is suited to your work requirements, and how do you get the best of both worlds? Understanding What Each Tool Is For The above table should provide you with an outline to the key comparisons between using MS Access or MS Excel for your data requirements. In an ideal world we all use Excel and Access interchangeably, one for its advanced mathematical calculations and statistical comparisons, the other for its ability to organise and display rafts of data in a structured...
Read the full article: Excel Vs. Access – Can A Spreadsheet Replace A Database?
from MakeUseOf http://ift.tt/1xoFW9y
via IFTTT
No comments:
Post a Comment