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)
