Exam 11: Connecting to External Data

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 her connection files listed in the Existing Connections dialog box.She should save the connections in the ____ folder.

Unless you specify a format,Excel will apply a ____ format to all columns.

Web query files are simple XML files,so you can view and edit their contents in Notepad._________________________

One way to structure text files is to use a(n)____.

The ____ formatting only option retrieves the text from a Web query along with simple formatting,but not advanced formatting such as hyperlinks or complicated table structures.

By using the ____ function along with an add-in program,a scientist or researcher can save hours of data entry time and focus on analysis.

One of the advantages of XML is that the XML author defines what constitutes a valid document.Documents that fail to meet the rules can be rejected by an XML program as invalid,thus ensuring ____.

-The item marked 1 in the accompanying figure is a ____ in a database table.

The point at which one column ends and another begins in the Text Import Wizard is called a(n)____________________ break.

____ has been widely used in database programs,Web programming,and word processing.

You can retrieve the Web page format using ____,which is the default option.

The following is a possible data source: ____.

If you refresh external data in the ____,you can work on other portions of the workbook as you wait for the data to be retrieved.

In an XML element,a(n)____ tag marks the end of the data value.

In the Query Wizard,click the ____ in front of a table name to expand the display of fields in that table.

The default folder for queries is the ____ folder on the hard disk.

Most software programs can both save and retrieve data in a text file format.

A(n)____________________ separates one column of data from another.

-In the accompanying figure,Item ____ points to the column headings.

Most software programs can both save and retrieve data in a(n)____ file format.