Exam 6: Integrating Access

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?

You can import data stored in a workbook into a new or existing database table.

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.

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.

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

When you need to export data from a database table to an Excel workbook, click the ____ tab on the Ribbon, and then click the Excel button in the Export group.

When you insert a merge field in a Word document, the field name is enclosed in double ____.

When you import data from a Word document, it is usually best to store it in a Word ____.

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 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) ____.

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

When you export data, you copy it from another Access database, an Excel workbook, a text file, or some other file format into an existing or new table in the current database.

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 wants to remove some of the recipients from the mail merge list so they do not receive the promotional mailing. What should she do?

You can use the ____ link in the Mail Merge task pane to add an address to the letter in the location of the insertion point.

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

When you start the mail merge from Access, ____.

Case AC 6-2 Ross is exporting Access data into Word. What should Ross do to get the export of the Access database into Microsoft Word started?

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.

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