Exam 8: Get Connected: Exchanging Data Between Access and Other Applications

PDF or XPS documents can be opened by their respective document readers, which are free downloads.

Rich Text Format (RTF) is a format that enables documents created in one software application to be opened with a different software application.

What do you do if you only want to export part of a table to Excel?

When importing a fixed-length text file, the values in any field must have the same number of characters.

When preparing an Excel spreadsheet to be imported into an Access database, the first row of the spreadsheet must have column headings that are recognized as field names by Access.

When importing a text file, ________ is a common file extension for files that are not fixed-length.

________ have consistent formatting, and are used to exchange information between computer applications.

Why should you examine the Access table in your source fie before linking it?

If you make a mistake when entering a hyperlink, you can edit the link by clicking and correcting it.

When you ________ an external table, you connect to the table without actually importing the table's data.

An attachment appears as a paperclip in a table.

PDF documents are the preferred format when exporting from Access.

Access creates a temporary file on your computer each time you open an attachment file.

Exporting tables and queries to Excel is usually predictable and consistent because of the similarity between an Access datasheet and an Excel spreadsheet.

One of the main reasons for importing a spreadsheet into Access is that you have more control over the imported data.

In Access, what is a reference to an external file called?

When you export a table to Excel, the field names become the column headings and the records become the rows in the Excel spreadsheet.

You are limited to one attachment per record.

________ is a useful format for basic formatted text documents such as instruction manuals, resumes, letters, and other documents.