Exam 9: Importing and Exporting Data

In the figure above, which item would help you copy data from another database into Access?

Linked tables cannot be related to other tables in an Access database. _____

ODBC stands for _____.

Which of the following programs is not able to share information with Access?

Rich Text Format can be opened and edited in Microsoft Word.

A(n) _____ file is a text file containing Extensible Markup Language tags that identify field names and data.

Describe when you would use the Saved Exports button on the EXTERNAL DATA tab.

____ makes a duplicate copy of the data in the Access database.

Database templates create sample tables and queries, but not forms and reports.

The RTF file format can be opened and edited in Microsoft Word . _____

When you publish data to Word from Access, an RTF format document is created.

Which type of template creates a traditional Access database?

To export a report as an email attachment, click the _____ button in the Export group of the tab on the Ribbon.

_____ connects an Access database to data in an external file, such as another Access database, Excel spreadsheet, or SQL Server database, but does not copy the data into the database.

_____ is a way to copy Access information to another database, spreadsheet, or file format.

The merge document is the Word document that contains the standard text for each form letter.

Which of the following is NOT a source from which Access can import data?

Aaron needs to send information from an Access report to his manager.  What is the advantage of emailing the report as a PDF file?

A(n)  _____ file contains field values separated by a common character; this could be a comma, tab, dash, or other character.

In the figure shown, which option would you choose to copy data into a new table in the existing database?