William works for a nationwide real estate agency.He uses the agency's website to promote the latest homes.He uses Access to store information concerning the home and Excel to analyze the data.Fall open houses include homes in Seattle,Chicago,and Denver.Spring open houses include tours of homes in Washington,D.C.,New Mexico,Alaska,and Montana.Summer home tours include Paris,Rome,Denmark,and Australia.William wants Excel to automatically refresh the connection between his Excel workbook and his Access database whenever the workbook is opened.He should click the Refresh data when opening the file check box in the Connection Properties dialog box.What steps should he 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

William works for a nationwide real estate agency.He uses the agency's website to promote the latest homes.He uses Access to store information concerning the home and Excel to analyze the data.Fall open houses include homes in Seattle,Chicago,and Denver.Spring open houses include tours of homes in Washington,D.C.,New Mexico,Alaska,and Montana.Summer home tours include Paris,Rome,Denmark,and Australia.​William wants Excel to automatically refresh the connection between his Excel workbook and his Access database whenever the workbook is opened.He should click the Refresh data when opening the file check box in the Connection Properties dialog box.What steps should he 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.

Quizplus · Accepted Answer

To open the Connection Properties dialog box in Excel, you should click the Data tab on the Ribbon, then click the Connections button in the Connections group. After that, you select the database you want to modify the connection for, and finally, click the Properties button. This sequence of actions allows you to access and adjust the connection settings, including setting the workbook to refresh data automatically when it is opened.

William Works for a Nationwide Real Estate Agency