HOW MS EXCEL DIFFERENT FROM MS ACCESS?
Answers
Answered by
3
- Excel is extensively used by financial analysts as it is used for analysis of data and draw insights from it. Excel has built-in rows and columns which help in referencing when applied formula on excel. Excel also has functions to make graphs, charts, summaries, and dashboards. On the other hand, Access is used basically for collecting and sorting of heavy data
- Access is used as a part of Relational Database Management Systems. Access is quite helpful in the operations of small businesses. As it does not have a limitation of data like excel and can also store various databases which are quite huge in size and numbers. On the other hand, Microsoft excel limitation if large dataset and used to run analysis on the file size becomes quite heavy in nature and also makes it difficult to draw insights from
Similar questions