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

When you save the steps that import data from a Microsoft Office Excel 2007 workbook, Access stores only the name of the Excel workbook.

Before importing or linking an Excel worksheet, you need to make sure the worksheet is in an appropriate format. Name four actions you should take to ensure correct format.

After you create an Access version of a table, you can open it in Datasheet view but not in Design view.

To import data from another Access database into the database that is currently open, click the Access button in the Import group on the External Data tab.

The csv (comma separated values)file often used in ____ is an example of a delimited file.

The ____ Wizard allows you to import easily an Excel worksheet.

In a delimited file, each record is on a separate line and the fields are separated by a special character called the delimiter.

Figure 1 The accompanying figure shows an Excel worksheet. The type of worksheet that can be converted to a table is one in which the data is stored as a ____, that is, a collection of rows and columns in which all the entries in a column represent the same type of data.

HTML is a language that defines data records on a page.

The ____ Wizard allows you to link data easily to an Excel worksheet

Common ____________________ are tabs, semicolon, commas, and spaces.

What can Joe do to make it easier the next time the employee asks for the report?

In a ____-width file, the width of any field is the same on every record.

If you move, rename, or modify linked tables, you can use the Linked Table Manager to update the links.

To view or print the report stored in the XPS file, use the XML Paper Specification Viewer.

Text files contain formatted characters including both readable characters, such as numbers and letters, and some special characters, such as tabs, carriage returns, and line feeds.

Phil has reviewed the file and found that each record is on a separate line and the fields are separated by commas. What type of file does Phil have?

Hyperlink Markup Language (HTML)is the standard language for creating and displaying Web pages.

When exporting data to a text file, you cannot export the data with formatting and layout.