Exam 11: Integration 2: Integrating Word Excel and Access

You can modify cell formatting of pasted data in Excel that is linked to the Access source table.

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

If Excel data is linked to an Access source table, you can delete any of the rows.

You cannot append Excel data to an existing table in Access.

After you import data into a table in Access, you cannot delete field names.​

You cannot paste a Word table into a new, blank Access table.​

If a column heading has the name Participants in an Excel worksheet, you can change it to Volunteers when you import it to an Access table.​

Before exporting data from Excel into Access, you need to remove titles, subtitles, charts, and any other extraneous data.

Excel contains ____ tools not available in Access.

When you open files c​reated in different applications, you should open them in the order they were created.

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

The Import Spreadsheet Wizard dialog box displays a preview of the Access table.​

In Word, you can click the ____ button to select the contents of an entire table.

You can enter data into an Access ____.

When you open files created in different applications, you need to create them on the same computer logged in as the same user.​

If an Access table is the ____ of the data in a table in Word, whenever you change the data in the Access table, the linked data in Word also changes.

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

When you link an Access table to an Excel worksheet, you cannot delete any of the columns or rows that contain copied data.​

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

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