Question 1

After exporting Excel data into Access, the column headings in the Excel spreadsheet become ____ in the Access table.

Accepted Answer

A)   data cells
B)   row ids
C)   record pointers
D)   field names

Question 2

Mary Lou Jacobs has asked you to test the quality of links from an Access table to an Excel spreadsheet and a Word document. In the figure below, the Tours table is linked to a table in Excel, which in turn is linked to a source Access table. The Guides table is directly linked to a source Access table.  After changing the Price field in record 1 (2010 Celebration) of the source Access Tours table to 5000, how do you verify that the tour Revenue changes to $75,000 in Excel and Word?

Accepted Answer

Switch to Excel, verify that the total r...

Question 3

After pasting data into Excel that is linked to an Access source table, you can ____.

Accepted Answer

A)   delete rows
B)   modify cell formatting
C)   delete columns
D)   modify the Access source table from Excel

Question 4

In the figure above, item 3 points to a field name change that occurred during the ____ process.

Accepted Answer

A)   export
B)   linking
C)   import
D)   embedding

Question 5

In Word, you can click the ____ button to select the contents of an entire table.

Accepted Answer

A)   Tables and Borders
B)   Insert Table
C)   Insert Hyperlink
D)   table select

Question 6

Before exporting data from Excel into Access, you need to remove titles, subtitles, charts, and any other extraneous data.

Accepted Answer

A) True 
 B)False

Exam 26: Integration Unit B: Integrating Word, Excel, and Access

In Word, you can click the ____ button to select the contents of an entire table.

Correct Answer
verified

After pasting data into Excel that is linked to an Access source table, you can ____.

Correct Answer
verified

Before exporting data from Excel into Access, you need to remove titles, subtitles, charts, and any other extraneous data.

Correct Answer
verified

Correct Answer
verified
Switch to Excel, verify that the total r...
View Answer

After exporting Excel data into Access, the column headings in the Excel spreadsheet become ____ in the Access table.

Correct Answer
verified

In the figure above, item 3 points to a field name change that occurred during the ____ process.

Correct Answer
verified

Exam 26: Integration Unit B: Integrating Word, Excel, and Access

In Word, you can click the ____ button to select the contents of an entire table.

Correct AnswerverifiedShow Answer

After pasting data into Excel that is linked to an Access source table, you can ____.

Correct AnswerverifiedShow Answer

Before exporting data from Excel into Access, you need to remove titles, subtitles, charts, and any other extraneous data.

Correct AnswerverifiedShow Answer

Correct AnswerverifiedSwitch to Excel, verify that the total r...View AnswerShow Answer

After exporting Excel data into Access, the column headings in the Excel spreadsheet become ____ in the Access table.

Correct AnswerverifiedShow Answer

In the figure above, item 3 points to a field name change that occurred during the ____ process.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Switch to Excel, verify that the total r...
View Answer

Correct Answer
verified

Correct Answer
verified