Name:     ID: 
 
Email: 

Access Lesson 6

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
nar001-1.jpg

Access Case 6-1
Kathleen 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
 



 
         Start Over