Question 1

You export an Access table to Word when you will not need to update the exported information when the database information changes.

Accepted Answer

A) True 
 B)False

Question 2

An Access table you import into Word is not ____.

Accepted Answer

A)   embedded
B)   editable
C)   linked
D)   lockedE) A) and D)
F) All of the above

Question 3

When you want to include an Access table in a Word document,you first export it to a document that is saved in ____________________ Format.

Accepted Answer

The answer of When you want to include an Access...

Question 4

When merging from Access to Word,you can initiate the merge process directly from Access by using the ____ feature to merge data contained in an Access query datasheet with a Word document.

Accepted Answer

A)   Merge All
B)   Merge it
C)   Combine Access and Word
D)   Merge it with Microsoft Office WordE) All of the above
F) B) and C)

Question 5

You can export an Access table to ____ when you want to use its features to filter,chart,analyze,or edit the table data.

Accepted Answer

A)   AutoCad
B)   Excel
C)   Word
D)   PowerPointE) B) and C)
F) C) and D)

Question 6

In the ____ dialog box,you can specify the criteria that each of the records you want to merge should meet.

Accepted Answer

A)   Start Mail Merge
B)   Mail Merge Recipients
C)   Filter and Sort
D)   Merge CriteriaE) A) and D)
F) B) and C)

Question 7

In the accompanying figure,the double arrow buttons in the center of the dialog box are used if you want to select all ____________________.

Accepted Answer

The answer of In the accompanying figure,the double arrow buttons...

Question 8

The ____ feature in Excel can perform calculations on sorted data,such as calculating the total amount that each company in the list spent on travel.

Accepted Answer

A)   Subtotal
B)   Sort
C)   SUM
D)   CalculateE) A) and D)
F) A) and C)

Question 9

The Address Block button is found on the ____ group.

Accepted Answer

A)   Name & Address
B)   Insert Address
C)   Write & Insert Fields
D)   AddressE) A) and D)
F) A) and C)

Question 10

In Access,the Query Wizard button appears in the ____ tab.

Accepted Answer

A)   FILE
B)   EDIT
C)   QUERY
D)   CREATEE) A) and D)
F) A) and C)

Question 11

An Access report that you export to an .rtf file is not linked to ____.

Accepted Answer

A)   the Access table
B)   Microsoft Word
C)   the Access database
D)   the .rtf fileE) C) and D)
F) A) and C)

Question 12

-The Access table in the accompanying figure has the ____ format applied.

Accepted Answer

A)   Banded Rows
B)   Alternating Rows
C)   Alternating Columns
D)   Banded ColumnsE) All of the above
F) B) and C)

Question 13

After you export an Access table to Excel,changes you make to the data in Access are also made to the data in Excel.

Accepted Answer

A) True 
 B)False

Question 14

In Excel,the Subtotal button appears in the ____ group of the DATA tab.

Accepted Answer

A)   Total
B)   AutoSum
C)   Outline
D)   CalculateE) All of the above
F) C) and D)

Question 15

In Access,the ____ is a dialog box where you can select all the fields that you want to include in the table you will merge with a form letter you create in Word.

Accepted Answer

A)   Simple Query Wizard
B)   Advanced Query Wizard
C)   Merge Query Wizard
D)   Word Query WizardE) None of the above
F) A) and B)

Question 16

The first step in merging an Access database with Word is to create a query datasheet.

Accepted Answer

A) True 
 B)False

Question 17

You can use the filtering options in ____ to select the records you would like to use in a merge.

Accepted Answer

A)   Microsoft Word
B)   Microsoft Access
C)   the Simple Wizard dialog box
D)   the Merge it With Microsoft Office Word dialog boxE) A) and C)
F) None of the above

Question 18

When merging from Access to Word,you can edit the recipients list in Word and use the ____________________ options to select the records you want to use in the merge.

Accepted Answer

The answer of When merging from Access to Word,you can...

Question 19

If you export an Access report to Word,you can use the tools in Word to convert the report into a(n) ____.

Accepted Answer

A)   list
B)   table
C)   chart
D)   outlineE) B) and C)
F) A) and B)

Question 20

To create a column chart in Excel,first select a range of data,then click the Insert Column Chart button in the Charts group on the ____ tab.

Accepted Answer

A)   INSERT
B)   CHART
C)   DATA
D)   FORMATE) B) and C)
F) A) and D)

Exam 10: Integration : Integrating Word, Excel, and Access

In the accompanying figure,the double arrow buttons in the center of the dialog box are used if you want to select all ____________________.

Correct AnswerverifiedShow Answer

When merging from Access to Word,you can edit the recipients list in Word and use the ____________________ options to select the records you want to use in the merge.

Correct AnswerverifiedShow Answer

If you export an Access report to Word,you can use the tools in Word to convert the report into a(n) ____.

Correct AnswerverifiedShow Answer

The Address Block button is found on the ____ group.

Correct AnswerverifiedShow Answer

In Access,the Query Wizard button appears in the ____ tab.

Correct AnswerverifiedShow Answer

In the ____ dialog box,you can specify the criteria that each of the records you want to merge should meet.

Correct AnswerverifiedShow Answer

An Access table you import into Word is not ____.

Correct AnswerverifiedShow Answer

The first step in merging an Access database with Word is to create a query datasheet.

Correct AnswerverifiedShow Answer

In Excel,the Subtotal button appears in the ____ group of the DATA tab.

Correct AnswerverifiedShow Answer

After you export an Access table to Excel,changes you make to the data in Access are also made to the data in Excel.

Correct AnswerverifiedShow Answer

In Access,the ____ is a dialog box where you can select all the fields that you want to include in the table you will merge with a form letter you create in Word.

Correct AnswerverifiedShow Answer

You export an Access table to Word when you will not need to update the exported information when the database information changes.

Correct AnswerverifiedShow Answer

You can use the filtering options in ____ to select the records you would like to use in a merge.

Correct AnswerverifiedShow Answer

You can export an Access table to ____ when you want to use its features to filter,chart,analyze,or edit the table data.

Correct AnswerverifiedShow Answer

-The Access table in the accompanying figure has the ____ format applied.

Correct AnswerverifiedShow Answer

An Access report that you export to an .rtf file is not linked to ____.

Correct AnswerverifiedShow Answer

When you want to include an Access table in a Word document,you first export it to a document that is saved in ____________________ Format.

Correct AnswerverifiedShow Answer

To create a column chart in Excel,first select a range of data,then click the Insert Column Chart button in the Charts group on the ____ tab.

Correct AnswerverifiedShow Answer

The ____ feature in Excel can perform calculations on sorted data,such as calculating the total amount that each company in the list spent on travel.

Correct AnswerverifiedShow Answer

When merging from Access to Word,you can initiate the merge process directly from Access by using the ____ feature to merge data contained in an Access query datasheet with a Word document.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified