True/False Indicate whether the statement is true or
false.
|
|
|
1.
|
Most word processors, including Word, can open files with the .rtf file name
extension.
|
|
|
2.
|
When data is formatted using comma separators, it is called limited data.
|
|
|
3.
|
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.
|
|
|
4.
|
When a field name in the data source contains a space, the merge field in Word
replaces the space with a question mark.
|
|
|
5.
|
You can use any document as a form letter, including documents that you create
from scratch or a template.
|
Multiple Choice Identify the choice that best completes the
statement or answers the question.
|
|
|
6.
|
You can export data to a(n) _____ format.
a. | Word document | c. | Excel workbook | b. | HTML document | d. | all of the
above |
|
|
|
7.
|
When you need to export data from a database table to a Word document, click the
____ tab on the Ribbon, and then click the Word button in the Export group.
a. | Internal Data | c. | Import Data | b. | External Data | d. | Export Data |
|
|
|
8.
|
In a CSV file, ____ separate the field values of each record in the data
source.
a. | commas | c. | colons | b. | cells | d. | semi-colons |
|
|
|
9.
|
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.
a. | External Data | c. | Internal Data | b. | Export | d. | Import |
|
|
|
10.
|
The data source for a form letter can be a ____.
a. | Word document | c. | Access database | b. | Excel workbook | d. | any of the
above |
|
|
|
11.
|
When you insert a merge field in a Word document, the field name is enclosed
in ____.
a. | angle brackets | c. | quotation marks | b. | parentheses | d. | none of the
above |
|
|
|
12.
|
When you start the mail merge from Access, ____.
a. | Word sets the data source for you | c. | Access sets the data source for
you | b. | You must choose a data source | d. | none of the
above |
|
|
|
13.
|
If you want to print form letters in alphabetical order based on a specific
field, you can click the ____ link to open the Filter and Sort dialog box with the Sort Records tab
selected.
a. | Sort | c. | Print | b. | Alphabetical | d. | Field |
|
|
|
14.
|
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 arrow to choose the filter operator, and then
type a value in the ____ text box.
a. | Compare to | c. | Comparison | b. | Field | d. | Sort by |
|
|
|
15.
|
You can filter mail merge records by clicking the ____ link in the Refine
recipient list section, which opens the Filter and Sort dialog box with the Filter Records tab
selected.
a. | Refine | c. | Sort | b. | Filter | d. | Edit |
|
|
|
16.
|
If the preview of the address block in the mail merge is correct, click OK. If
it is incorrect, click ____ to make adjustments.
a. | Match Fields | c. | Edit Fields | b. | Filter Fields | d. | Format Fields |
|
|
|
17.
|
After verifying that your form letters are correct, click the ____ link at
the bottom of the Mail Merge pane.
a. | Merge | c. | Complete | b. | Next: Complete the merge | d. | Next |
|
|
|
FIGURE 6-1 Access Case 6-1Kathleen is working with
a large recipient list for an upcoming promotional mailing. She has opened the Mail Merge
Recipients dialog box above. Please refer to the figure above as you answer the questions
below.
|
|
|
18.
|
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?
a. | clear the check box | b. | double-click the recipient’s name and
click Remove | c. | fill in their name in the Data Source box | d. | none of the
above |
|
|
|
19.
|
Kathleen needs to put the mail merge recipient list in alphabetical order.
What is her next step?
a. | Write a sort command and fill it in the Data source box | b. | Click
“Filter” under Refine recipient list | c. | Click “Sort” under Refine recipient
list | d. | none of the above |
|
|
|
Access Case 6-2 Ross is exporting Access data into Word. Please answer
the questions below.
|
|
|
20.
|
After the file is exported into Word, what file format will it be in?
a. | .doc | c. | .rtf | b. | .docx | d. | .htm |
|