Exam 6: Access Lesson 6: Integrating Access

The Text fields have the default properties as well, which includes a default Field Size property of 385 characters.

If you are creating a document from scratch, the first step is to select the type of document you are creating. For a form letter, choose the ___________________ option button.

You can add merge fields individually at the location of the insertion point by clicking the Insert Merge Field button in the Write & Insert Fields group on the ____ tab.

When data is formatted using comma separators, the comma is called a limiter .

FIGURE AC 6-1 Referring to Figure AC 6-1 above, the data source for the mail merge is a(n) ____.

When you save database data in another file format, you ____________________ the data from the database.

If you select the option for Access to create a primary key, Access will create a field named ID at the beginning of the table and assign it the AutoNumber data type.

If the preview of the address block in the mail merge is correct, click OK. If it is incorrect, click ____ to make adjustments.

If you want to print form letters in alphabetical order based on a specific field, you can click the Sort link to open the Filter and Sort dialog box with the ___________________ tab selected.

Case AC 6-1 Kathleen is working with a large recipient list for an upcoming promotional mailing. She has opened the Mail Merge Recipients dialog box. Kathleen needs to put the mail merge recipient list in alphabetical order. What is her next step?

Most word processors, including Word, can open files with the .rtf file name extension.

When a field name in the data source contains a space, the merge field in Word replaces the space with a question mark.

The default setting for a mail merge is to print one record in the data source.

If you don't want to print the letter for the currently displayed record, click Exclude this recipient in the Mail Merge pane.

The data source for a form letter can be a(n) ____.

When you export the data to Excel, it will be saved in Excel format, with each field in the table stored in a worksheet column and each record in the table stored as a row in the worksheet.

The _____________________ field stores unique values for each record in a table.

To import data and create a new table, click the External Data tab on the Ribbon, and then click the Text File button in the ____ group.

You can export data to a(n) _____ format.

To create a filter using the Filter and Sort dialog box, use the Field list arrow to select the field to filter, use the Comparison list arrow to choose the filter operator, and then type a value in the ____ text box.