Question 1

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 
A)  Tables and Borders 
B)  Insert Table 
C)  Insert Hyperlink 
D)  table select

Question 2

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 
A)  export 
B)  linking 
C)  import 
D)  embedding

Question 3

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 4

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 
A)  delete rows 
B)  modify cell formatting 
C)  delete columns 
D)  modify the Access source table from Excel

Question 5

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 
A)  data cells 
B)  row ids 
C)  record pointers 
D)  field names

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

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

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

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

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

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

Word 2007 Unit A: Creating Documents With Word 2007

Word 2007 Unit B: Editing Documents

Word 2007 Unit C: Formatting Text and Paragraphs

Word 2007 Unit D: Formatting Documents

Outlook 2007 Unit A: Getting Started With E-Mail

Outlook 2007 Unit B: Managing Information Using Outlook

Powerpoint 2007 Unit A: Creating a Presentation in Powerpoint 2007

Powerpoint 2007 Unit B: Modifying a Presentation

Powerpoint 2007 Unit C: Inserting Objects Into a Presentation

Powerpoint 2007 Unit D: Finishing a Presentation

Access 2007 Unit A: Getting Started With Access 2007

Access 2007 Unit B: Building and Using Queries

Access 2007 Unit C: Using Forms

Access 2007 Unit D: Using Reports

Excel 2007 Unit A: Getting Started With Excel 2007

Excel 2007 Unit B: Working With Formulas and Functions

Excel 2007 Unit C: Formatting a Worksheet

Excel 2007 Unit D: Working With Charts

Concepts Unit A: Understanding Essential Computer Concepts

Office 2007 Unit A: Getting Started With Microsoft Office 2007

Windows Vista Unit A: Getting Started With Windows Vista

Windows Vista Unit B: Understanding File Management

Windows Xp Unit A: Getting Started With Windows Xp

Windows Xp Unit B: Understanding File Management

Integration Unit A: Integrating Word and Excel

Integration Unit C: Integrating Word, Excel, Access, and Powerpoint

Internet Unit A: Getting Started With Internet Explorer 7

Filters

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.

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

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

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

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

Word 2007 Unit A: Creating Documents With Word 2007

Word 2007 Unit B: Editing Documents

Word 2007 Unit C: Formatting Text and Paragraphs

Word 2007 Unit D: Formatting Documents

Outlook 2007 Unit A: Getting Started With E-Mail

Outlook 2007 Unit B: Managing Information Using Outlook

Powerpoint 2007 Unit A: Creating a Presentation in Powerpoint 2007

Powerpoint 2007 Unit B: Modifying a Presentation

Powerpoint 2007 Unit C: Inserting Objects Into a Presentation

Powerpoint 2007 Unit D: Finishing a Presentation

Access 2007 Unit A: Getting Started With Access 2007

Access 2007 Unit B: Building and Using Queries

Access 2007 Unit C: Using Forms

Access 2007 Unit D: Using Reports

Excel 2007 Unit A: Getting Started With Excel 2007

Excel 2007 Unit B: Working With Formulas and Functions

Excel 2007 Unit C: Formatting a Worksheet

Excel 2007 Unit D: Working With Charts

Concepts Unit A: Understanding Essential Computer Concepts

Office 2007 Unit A: Getting Started With Microsoft Office 2007

Windows Vista Unit A: Getting Started With Windows Vista

Windows Vista Unit B: Understanding File Management

Windows Xp Unit A: Getting Started With Windows Xp

Windows Xp Unit B: Understanding File Management

Integration Unit A: Integrating Word and Excel

Integration Unit C: Integrating Word, Excel, Access, and Powerpoint

Internet Unit A: Getting Started With Internet Explorer 7

Filters