Exam 6: Access: Integration Feature - Sharing Data Among Applications

When you link a worksheet to an Access database, you can make changes to the table in Access.

To export data to Excel, select the table or query to be exported, and then click the Excel button in the Export group on the Home tab.

In standard-width files, the width of any field is the same on every record.

Critical Thinking Questions Case 2 Someone in the Marketing department sent Phil a file with the extension asc. Phil needs to import this file into the Access database he uses for customer contacts. What type of file is a file with an asc extension?

Because you cannot export data to the standard Word format, you must export the data as a(n)___ file which Word can access.

You cannot export data to the standard Word format.

You can use a set of saved import steps from within Access by clicking the Saved Imports button on the ____ tab.

You can publish a report either as a PDF or ____________________ file.

When you export XML data, the schema is saved in a file with the ____________________ extension.

To close a database, click the Office Button to display the Office Button menu, and then click ____ on the Office Button menu.

The Linked Table Manager button that allows you to update links is located on the ____ tab.

When you export XML data, the presentation is saved in a file with the ____________________ extension.

____ is the process of copying database objects to another database, to a worksheet, or to some other format so another application can use the data.

When you export XML data, the data is saved in a file with a(n)____________________ extension.

The accompanying figure shows the Navigation Pane. An alternate way to export an object from a database is to right-click the database object in the Navigation Pane, point to ____, and then click the appropriate format.

To publish a report as either a PDF or XPS file, select the report in the Navigation Pane and click the 'PDF or XPS' button in the Export group on the ____ tab.

The accompanying figure shows the Navigation Pane. To make changes to a table s structure after you import it, click ____ on the table s shortcut menu.