Exam 9: Importing and Exporting Data

Lara works at a large corporation.  Explain how the Application Parts features could help her improve an existing database.

Describe how Aaron could use the Issues option in the Quick Start category to enhance an existing database.

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

Which of the following options means that if a value in the primary key field is modified, all values in the foreign key field are automatically updated as well?

If you link data to an Access database, data can be edited in the original file, but not in the Access database.

Importing is a process to quickly link to, but not copy data from an external source to an Access database.

Merge fields are codes that are replaced with the field values when the mail merge is processed.

Why should Cascade Updated Related Fields and Cascade Delete Related Records be used with caution?

A database _____ is a tool that you use to quickly create a new database based on a particular subject.

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

Exporting is the opposite of importing.

The file format RTF stands for _____.

PDF stands for _____.

The _____ feature determines when a line of text extends into the right margin of the page and automatically forces the text to the next line without pressing [Enter].

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

Microsoft _____ is the word-processing program in the Microsoft Office suite.

Identify three different techniques to copy Access data to other applications.

In a Word merge data from an Access table or query is combined into a Word form letter.

If you change data in its original location and it is linked to an Access database, you must also update it in the Access database.

Once a linked table is related to other objects in a database, it can be a part of _____ that use fields from multiple tables.