Access Excel Word Integration

When the Paste Special dialog box is open in Word, select the ____ option to paste text as formatted text.

Formatted Text (RTF)

You use the ____ command in Access to import data from an outside source.

Get External Data

To import an Excel worksheet into Access, click the External Data tab and then click the Excel button in the _____ group.

Import & Link

A tool that enables you to transfer Excel data into an Access table.

Import Spreadsheet Wizard

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

Number

Command used to update data in Excel that is linked to an Access source file.

Update

You can import data into Access from ____.

another Access database

You can choose to import Excel data directly into a new table or you can ____ the data to an existing table.

append

Excel contains ____ tools not available in Access.

calculation

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

chart

With the exception of a(n) ____________________, the Paste command allows you to paste an object without creating a link.

chart

You link an Access table to Excel and then to Word when you want the data in all three applications to always remain ____.

current

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

data

During the process of importing data from Excel into Access, you can change the field names and even ____ of selected fields.

data types

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

field names

If you want to import additional records to an existing database, make sure that the imported Excel data contains the same number of ____________________ as the database.

fields

After pasting a table into Word as a link, you can modify the ____________________ of the pasted table so that the table is attractive and communicates the data clearly.

formatting

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

importing

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

modify cell formatting

If you enter the formula =C2*D2 into a cell, you are performing a(n) _____ calculation.

multiplication

In the Get External Data - Excel Spreadsheet dialog box, the Browse button ____.

opens a dialog box

You can copy an existing table from Word and paste it into a new Access ____________________.

table

If you are adding ten Word records to an existing Access table, you should ensure that the Access table has ____.

the same number of records

By integrating information created in Word, Excel, and Access, the information ____.

works together

To create a new database, click the __________ desktop database button.

Blank

To create a new desktop database in Access, click the _____ button.

Blank desktop database

To copy a table in Word, click the table select button, and then click the Copy button in the _____ group.

Clipboard

Used to copy an Access table and paste it into Excel as a link.

Copy and Paste Special commands

You can enter data into an Access ____.

Database

When you open a linked Excel file, click _____ if prompted and click Update in response to the message.

Enable Content

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

Excel

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

External Data

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

Font

In Excel, to adjust the column widths to Autofit, select the data, click the ____________________ button in the Cells group, then click AutoFit Column Width.

Format

Option that appears in the Paste Special dialog box.

Formatted Text (RTF)