Match each term with the statement that best describes it. 7. Table template 8.

ID: 452208 • Letter: M

Question

Match each term with the statement that best describes it.

7. Table template

8. Database template

9. Exporting

10. Main document

11. Linking

12. Delimited text file

13. Mail merge

14. Importing Match

a. A tool used to quickly create a single table within an existing database

b. A file used to determine how a letter and Access data will be combined

c. A file that stores one record on each line, with the field values separated by a common character such as a comma, tab, or dash

d. A way to copy Access information to another database, spreadsheet, or file format

e. The process of converting data from an external source into an Access database

f. A way to connect to data in an external source without copying it

g. A tool used to quickly create a new database based on a particular subject, such as assets, contacts, events, or projects

h. To combine data from an Access table or query into a Word form letter, label, or envelope to create mass mailing documents

Select the best answer from the list of choices.

15. Which of the following is not true about database templates?

a. They cover a wide range of subjects, including assets, contacts, events, or projects.

b. Microsoft provides online templates in areas such as business and personal database applications.

c. They create multiple database objects.

d. They analyze the data on your computer and suggest database applications.

16. Which of the following is not true about exporting?

a. Access data can be exported into Excel.

b. Access data can be exported to Word.

c. Exporting creates a copy of data.

d. Exporting retains a link between the original and target data files.

17. Which of the following is not a file format that Access can import?

a. Word

c. Access

b. Excel

d. HTML

18. Which of the following file formats allows you to send information that cannot be modified?

a. XLS

c . RTF

b. HTM

d. PDF

19. Which is not true about enforcing referential integrity?

a. It is required for all one-to-many relationships.

b. It prevents records from being deleted on the “one” side of a one-to-many relationship that have matching records on the “many” side.

c. It prevents records from being created on the “many” side of a one-to-many relationship that do not have a matching record on the “one” side.

d. It prevents orphan records.

20. Which of the following is not true about linking?

a. Linking copies data from one data file to another.

b. Access can link to data in an HTML file.

c. Access can link to data in an Excel spreadsheet.

d. You can edit linked data in Access.

Explanation / Answer

Match each term with the statement that best describes it.

7. Table template : a. A tool used to quickly create a single table within an existing database

8. Database template : g. A tool used to quickly create a new database based on a particular subject, such as assets, contacts, events, or projects

9. Exporting : d. A way to copy Access information to another database, spreadsheet, or file format

10. Main document : b. A file used to determine how a letter and Access data will be combined

11. Linking : f. A way to connect to data in an external source without copying it

12. Delimited text file : c. A file that stores one record on each line, with the field values separated by a common character such as a comma, tab, or dash

13. Mail merge : h. To combine data from an Access table or query into a Word form letter, label, or envelope to create mass mailing documents

14. Importing Match : e. The process of converting data from an external source into an Access database