Exam 11: Connecting to External Data

Databases such as those created in Access are examples of _______ databases which reduce data redundancy and increase data integrity.

A(n)____________________ is a collection of data arranged in rows and columns.

-The item marked 2 in the accompanying figure is a _______ in a database table.

For a fixed-width text file to import correctly into Excel,there must be some way for the Text Import Wizard to know where each column begins and ends.

The general form of a URL for a file located on your computer will be _______.

In addition to specifying the format of data using the Text Import Wizard,you can also indicate which columns you want to import.

To prevent other users from updating a data source without permission,what should Audra do?

Although $\underline {\text { text } }$ files contain only raw,unformatted data,they are very useful in situations when you want to share data across software programs and computer systems._________________________

In XML,the rules about which elements are required and which are not are stored in a document called the _______.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Format that allows for text formatting styles including boldface,italic,and color

When you _______ data,you specify which records you want to retrieve using specific criteria.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A collection of data stored in rows and columns

A(n)_______ might ask something like,"What are the names of all the stocks in the portfolio,and what are their corresponding ticker symbols?"

In a(n)____________________ text file,each column will start at the same location in the file.

To select fields within the Query Wizard,you can _______ the field name and Excel will automatically move it to the list of selected columns in your query.

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 learns that an advantage of using XML elements in a worksheet is that it allows the user to attach elements to specific cells.To map an XML document directly into an Excel table,William should click the From Other Sources button in the Get External Data group on the DATA tab,and then click _______.

One way to interact with a database is with a query language.The most popular query language is _______.

When you use Excel to connect to a text file,the _______ Wizard determines whether the data is in a fixed-width format or a delimited format.

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

The _______ formatting option retrieves all simple as well as advanced HTML formatting features,including hyperlinks.