Doug needs to maintain an Excel spreadsheet but also needs to use the same data in an Access database. He wants to make sure that any updates to the Excel spreadsheet are automatically updated in the Access database. In the figure above, which option should he choose and why?

Question

Doug needs to maintain an Excel spreadsheet but also needs to use the same data in an Access database.  He wants to make sure that any updates to the Excel spreadsheet are automatically updated in the Access database.  In the figure above, which option should he choose and why?

Quizplus · Accepted Answer

The Answer of  Doug needs to maintain an Excel spreadsheet but also needs to use the same data in an Access database.  He wants to make sure that any updates to the Excel spreadsheet are automatically updated in the Access database.  In the figure above, which option should he choose and why?

Doug Needs to Maintain an Excel Spreadsheet but Also Needs