Exam 11: Integration 2: Integrating Word Excel and Access

Explore all topics

If you want to import additional records to an existing database, the imported Excel data must contain the same number of fields (columns) in the database.

(True/False)

4.7/5

(41)

Question 21

To add new fields to an Access table from a Word table, click New Field at the top of the blank column in the Access table.

(True/False)

4.8/5

(41)

Question 22

Copying a table from Word and pasting it into a new or existing table in Access saves typing time and minimizes errors.

(True/False)

4.9/5

(38)

Question 23

In Microsoft Office 2016, the program that is used to make calculations with data is ____.

(Multiple Choice)

4.9/5

(31)

Question 24

Identify the letter of the choice that best matches the phrase or definition.

Premises:

Automatically links to an Excel source file after being pasted into Word.

Responses:

chart

Formatted Text (RTF)

Update

Correct Answer:

Verified

Automatically links to an Excel source file after being pasted into Word.

(Matching)

4.7/5

(34)

Question 25

Explain how to import an Excel worksheet into Access.

(Essay)

4.7/5

(43)

Question 26

Explain how to link an Access table to Excel and Word.

(Essay)

4.8/5

(27)

Question 27

You can minimize typing time by ____ Excel data directly into a table in an Access database.

(Multiple Choice)

4.8/5

(23)

Question 28

You can perform calculations based on the pasted data in Excel that is linked to an Access source table. _________________________

(True/False)

4.7/5

(29)

Question 29

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

(Multiple Choice)

4.9/5

(36)

Question 30

You can increase efficiency by integrating the information you create in Word, Excel, and Access.

(True/False)

4.9/5

(43)

Question 31

To import data into an Access database, click the _____ tab.

(Multiple Choice)

4.9/5

(42)

Question 32

You can import data into Access from ____.

(Multiple Choice)

4.8/5

(34)

Question 33

When you email your files to another user, the links will not work.

(True/False)

4.9/5

(33)

Question 34

You cannot copy an Access table and paste it directly into Word as a link. _________________________

(True/False)

4.9/5

(39)

Question 35

Mary Lou Jacobs has asked you to test the quality of links from an Access table to an Excel spreadsheet and a Word document. The Experiences table in the Word document is linked to a table in Excel, which in turn is linked to a source Access table. The Leaders table is directly linked to a source Access table. After changing the Price field for the first record (Coastal Marine Conservation) of the source Access Experiences table to 5500, how do you verify that the experiences Revenue changes to $66,000.00 in Excel and Word?

(Short Answer)

4.8/5

(31)

Question 36

A workbook that you plan to export from Excel into Access should only contain the ____ that you want to appear in the Access table.

(Multiple Choice)

4.8/5

(32)

Question 37

To add borders to a range in Excel, select the range and click the Borders list arrow in the _____ group.

(Multiple Choice)

5.0/5

(37)

Question 38

To apply the accounting format to a range of selected cells, click the Accounting Number Format button in the ____________________ group.

(Short Answer)

4.9/5

(35)

Question 39

Be sure to click the Excel button in the Export & Link group when transferring data from Excel into Access. _________________________

(True/False)

4.8/5

(36)

Question 40

Showing 21 - 40 of 75

Exam 11: Integration 2: Integrating Word Excel and Access

If you want to import additional records to an existing database, the imported Excel data must contain the same number of fields (columns) in the database.

To add new fields to an Access table from a Word table, click New Field ​at the top of the blank column in the Access table.

Copying a table from Word and pasting it into a new or existing table in Access saves typing time and minimizes errors.​

In Microsoft Office 2016, the program that is used to make calculations with data is ____.

Explain how to import an Excel worksheet into Access.

Explain how to link an Access table to Excel and Word.

You can minimize typing time by ____ Excel data directly into a table in an Access database.

You can perform calculations based on the pasted data in Excel that is linked to an Access source table. _________________________

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

You can increase efficiency by integrating the information you create in Word, Excel, and Access.

To import data into an Access database, click the _____ tab.​

You can import data into Access from ____.

When you email your files to another user, the links will not work.​

You cannot copy an Access table and paste it directly into Word as a link. _________________________

A workbook that you plan to export from Excel into Access should only contain the ____ that you want to appear in the Access table.

To add borders to a range in Excel, select the range and click the Borders list arrow in the _____ group.​

To apply the accounting format to a range of selected cells, click the Accounting Number Format button in the ____________________ group.

Be sure to click the Excel button in the Export & Link group when transferring data from Excel into Access. _________________________

Access 1: Getting Started With Access

Access 2: Building and Using Queries

Access 3: Using Forms

Access 4: Using Reports

Essential: Understanding Essential Computer Concepts

Excel 1: Getting Started With Excel 2016

Excel 2: Working With Formulas and Functions

Excel 3: Formatting a Worksheet

Excel 4: Working With Charts

Integration 1: Integrating Word and Excel

Integration 3: Integrating Word Excel Access and Powerpoint

Office: Getting Started With Office 2016

Outlook 1: Getting Started With Email

Outlook 2: Managing Information Using Outlook

Powerpoint 1: Creating a Presentation in Powerpoint 2016

Powerpoint 2: Modifying a Presentation

Powerpoint 3: Inserting Objects Into a Presentation

Powerpoint 4: Finishing a Presentation

Windows 1: Getting Started With Windows 10

Windows 2: Understanding File Management

Word 1: Creating Documents With Word 2016

Word 2: Editing Documents

Word 3: Formatting Text and Paragraphs

Word 4: Formatting Documents

Filters

To add new fields to an Access table from a Word table, click New Field at the top of the blank column in the Access table.

Copying a table from Word and pasting it into a new or existing table in Access saves typing time and minimizes errors.

To import data into an Access database, click the _____ tab.

When you email your files to another user, the links will not work.

To add borders to a range in Excel, select the range and click the Borders list arrow in the _____ group.