Exam 9: Importing and Exporting Data

To set a startup form, click the FILE tab, then click _____

Which program would be best suited to entering, editing, and managing large paragraphs of text?

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

You can establish referential integrity with a linked table.

Exporting is the opposite of importing.

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

A(n) _____ text file typically contains one record on each line, with the field values separated by a common character.

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

Doug needs to maintain an Excel spreadsheet but also needs to use the same data in an Access database.  He wants to make sure that any updates to the Excel spreadsheet are automatically updated in the Access database.  In the figure above, which option should he choose and why?

Microsoft _____ is the spreadsheet program within the Microsoft Office suite.

Enforce Referential Integrity helps prevent records in the "many" table that don't have a matching record in the "one" table.

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

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

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

Swipe and drop is a technique to copy Access data to another application.

Some templates are _____  which means they are available to download from the Microsoft Office Online Web site.

Which of the following options means that if a record on the "one" side of one-to-many relationship is deleted, all records in the "many" table are also deleted?

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

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

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