Importing Data

1. Importing Data Chapter 11 - Review

2. Review ______ data consists only of characters that you can type on a keyboard and does not contain any special formatting. Text Groups or fields of data often are separated from one another with a __________ character that does not otherwise occur in the data. delimiter When the Excel Text Import Wizard imports text data, it indicates the beginning of each new column of data with what? a vertical line called a column break

3. comma separated CSV Review Text files in which values are separated from one another with commas have the special name ______ _________ values. People often use the abbreviation ______ to refer to these types of files. A _________ is a collection of related information about one object that is stored in a database table. record By using ________ _______, also called filtering, you limit the records retrieved from a table to those matching certain characteristics. selection criteria

4. Review When Excel reruns a database query, it retrieves the most recent information from a database table. You can right-click anywhere in the imported data and then click the _________ Data command to obtain the latest information. Refresh To use a query to import information from two related tables, you must first link two tables based on a column found in both tables. You (or Microsoft Query) perform a(n) ______ operation to link the tables. join

5. Review Text Import The ______ ______ Wizard appears when you open a text file in Excel. Text data appearing in the same columns throughout the data are called ______ length data. fixed Data in which fields are separated by commas are called _______ separated ______, or CSVs. comma values

6. Structured Language Review Double-click a column break in the Text Import Wizard to ______ the column break. delete Before you can use Microsoft Query to retrieve information from a data base, you must first define a ______ source. data The standard language for sending commands to databases is called SQL, which stands for ___________ Query ____________.

7. Review A _________ key is a table column whose values are unique for each record in a table. primary Explain why you might want to save a query. Once you have returned data into an Excel worksheet, is that it? You might want to run it again after the data inthe worksheet has changed or been modified over time.

8. Review What does the term “aggregate data” mean when considering a database query? Microsoft Query can provide five types of calculations on query data. They are average, count, maximum, minimum, and sum. The calculations are called aggregate calculations because they cumulate information about groups of data.