Exam 10: Importing and Exporting Data

A common example of a delimited text file is a(n) _____ file.

_____ 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.

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

-In the figure above, item 3 points to the ____.

If referential integrity is applied to a one-to-many relationship, what happens?

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

Cascade Delete Related Records automatically deletes all records in the ____ if the record with the matching key field in a "one" table is deleted.

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

ODBC stands for _____.

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

-In the figure above, the relationship between the Courses and Materials tables is a(n) ____.

Cascade Update Related Fields automatically updates the data in the primary key field when the matching foreign key field is changed.

Match the following terms with the best choice. -Copying data from an external file into an Access database

Databases created by templates can be modified for your specific needs.

When you publish to Word from Access, the resulting document is in which file format?

Why might you use a database template in a business environment?

In the Relationships window, a linking line without referential integrity shows the "one" and "many" symbols. _____

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?

You can establish referential integrity with a linked table.

PDF stands for _____.