Case-Based Critical Thinking Questions
Case 11-2
Sadra works for a local travel agency.She uses the agency's Web site to promote the latest tours.She uses Access to store information concerning the tours and Excel to analyze the data.Fall tours include trips to Honolulu,Seattle,Chicago,and Denver.Spring tours include trips to Washington,D.C. ,New Mexico,Alaska,and Montana.Summer tours include Paris,Rome,Denmark,and Australia.
-Sadra wants Excel to automatically refresh the connection between her Excel workbook and her Access database whenever the workbook is opened.She should click the Refresh data when opening the file check box in the Connection Properties dialog box.What steps should she take to open the Connection Properties dialog box?
A) Click the Data tab on the Ribbon,click the Connections button in the Connections group,then click the Connection button.
B) Click the Data tab on the Ribbon,click the Connections button in the Connections group,select the database,then click the Properties button.
C) Click the Edit tab on the Ribbon,then click the Connections button in the Connections group.
D) Click the Edit tab on the Ribbon,click the Connections button in the Connections group,select the database,then click the Properties button.

Question

Quizplus · Accepted Answer

To open the Connection Properties dialog box, Sadra should first click the Data tab on the Ribbon. Then, she should click the Connections button in the Connections group and select the database. Finally, she should click the Properties button to open the Connection Properties dialog box. Option B describes the correct steps.