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

What are the two most common types of text files that can be imported into Access?

What is the disadvantage of linking an Excel spreadsheet from Access?

For an import to be successful,column headings and data formats should be an exact match,and in the same order,to those in your database.

When you export an object from Access to Word,Access creates a file in the PDF format.

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

The Access data type that enables you to link to any file on your computer or any Web site on the Internet is called ________.

Word and Excel files are compressed by Access when you attach them.

When there is a file in the ________ field a paperclip appears in the field.

The ________ file format was created by Adobe Systems for document exchange independent of software application and operating system environment.

Before exporting a table to another database,the new database has to be created.

You can ________ information from Access to another file format such as Word,Excel or PDF.

Why would you export the structure of a table to a different database and not the data?

A hyperlink field enables you to attach multiple files of different types.

How do you insert blank lines above a table after exporting it from Access into Word?

Exporting data from Access to Excel is generally very complicated because the format of Access is different than Excel.

The ________ file format does not allow you to edit the exported documents.

Tables,queries,forms and reports can all be exported to a PDF or XPS document.

When you export a table structure from one Access database to another,the new database has to be created.

JPEG and other photo formats increase the database size byte for byte.

After you export an Access table to an RTF file,the file cannot be edited in Word.