William Works for a Nationwide Real Estate Agency

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.