When choosing between Access and Excel, it is best to use Excel in all of the following circumstances EXCEPT:
A) you only need a single worksheet to manage data.
B) you need to manage primarily of numeric data.
C) you need to run a series of "what if" scenarios .
D) you need to group, sort, and total data based on various parameters.

Question

Quizplus · Accepted Answer

Excel is well-suited for managing numeric data, running "what if" scenarios, and handling tasks that require only a single worksheet. However, when it comes to grouping, sorting, and totaling data based on various parameters, Access is generally more powerful and efficient, especially for complex queries and managing relational data.

When Choosing Between Access and Excel, It Is Best to Use