Multiple Choice
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.
Correct Answer:

Verified
Correct Answer:
Verified
Q1: Database tables can be inserted directly into
Q34: <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB5278/.jpg" alt=" -In the accompanying
Q35: In addition to delimited text,you can also
Q36: The _ filename extension identifies a file
Q37: In the Text Import Wizard,the Preview
Q41: The _ Wizard lets you preview the
Q44: _ fields are the fields that appear
Q60: The _ formatting option retrieves all simple
Q79: A data _ is any file that
Q84: MATCHING<br>Identify the letter of the choice that