Exam 11: Integration 2: Integrating Word Excel and Access

Explain how to open linked files and enable the content.

You can copy a table created in Word into an Access table . _________________________

You cannot import data into an Access database table from a text file.

Describe how to link an Access table to Excel and then to Word.

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

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

To update a field in a Word table that is linked to an Access table, right-click the table click Refresh Field.​

When you create a new database, Access automatically creates a blank table called New .​ ____________________

You do not need to close an Access table before you check if linked data has been updated in Excel and Word.​

When you add data from one table to an existing table, you need to make sure that the number of records is the same in both tables.

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

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