Mary Lou Jacobs has asked you to test the quality of links from an Access table to an Excel spreadsheet and a Word document. In the figure below, the Tours table is linked to a table in Excel, which in turn is linked to a source Access table. The Guides table is directly linked to a source Access table. After changing the Price field in record 1 (2010 Celebration) of the source Access Tours table to 5000, how do you verify that the tour Revenue changes to $75,000 in Excel and Word?

Question

Mary Lou Jacobs has asked you to test the quality of links from an Access table to an Excel spreadsheet and a Word document. In the figure below, the Tours table is linked to a table in Excel, which in turn is linked to a source Access table. The Guides table is directly linked to a source Access table.  After changing the Price field in record 1 (2010 Celebration) of the source Access Tours table to 5000, how do you verify that the tour Revenue changes to $75,000 in Excel and Word?

Quizplus · Accepted Answer

The Answer of Mary Lou Jacobs has asked you to test the quality of links from an Access table to an Excel spreadsheet and a Word document. In the figure below, the Tours table is linked to a table in Excel, which in turn is linked to a source Access table. The Guides table is directly linked to a source Access table.  After changing the Price field in record 1 (2010 Celebration) of the source Access Tours table to 5000, how do you verify that the tour Revenue changes to $75,000 in Excel and Word?

Mary Lou Jacobs Has Asked You to Test the Quality