Exam 11: Integration 2: Integrating Word Excel and Access

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

If you want to paste a Word table into an Access table that already contains records, you need to make sure that the Word table contains the same number of ___________________ as the Access table.

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.

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

The Paste Special command does not provide formatting options for pasted objects that are not linked.

You can import data from an Excel spreadsheet into Access.

If you import Excel data into Access without links, any changes you make to the Excel source data will be reflected in the Access table.

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

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

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

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

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

If you want to select from a variety of formatting options when pasting an object into Word, you should use the Paste Format command. _________________________

Explain the options you have for copying a Word table into Access.

​When you create a link between an Access database and an Excel worksheet, you can perform calculations but you cannot create charts.

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.

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

After changing the last name in record 1 of the source Access Leaders table to Chow, how do you verify that Last Name changes to Chow in Word?

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