Unlock document.
This document is partially blurred.
Unlock all pages and 1 million more documents.
Get Access
Access Module 7.2 Alternate Assignment (15 Points)
Match each term with the statement that best describes it.
1. Subdatasheet _____ a. Field used in a child (“many”) table to establish a
one-to-many relationship
2. Currency data type _____ b. Use this with fields that store fractional values
3. Importing ______ c. A whole number
4. Foreign key field ______ d. A way to copy information from another
database, spreadsheet, or file format into an
Access database
5. Referential integrity ______ e. Use this with fields that store integers
6. Primary key field ______ f. A way to connect to data in an external source
without copying it
7. Number data type ______ g. A field that contains unique information for each
record in that table
8. Integer ______ h. Shows related records from a child (“many”)
table
9. Linking i. A set of rules that prevent the creation of orphan
records in the child (“many”) table
10. What would be the best data type for a field that stores prices in dollars and cents?
a. Short Text c. Number
b. Currency d. AutoNumber
11. What would be the best data type for a field that stores the quantity of various car parts in
inventory?
a. Short Text c. Number
b. Currency d. AutoNumber
12. Which of the following is not a file format that Access can import?
a. Access c. Excel
15. Which of the following is not true about linking?
a. Access can link to data in an Excel spreadsheet
b. Linking copies data from one data file to another
c. Access can link to data in an HTML file
d. You can edit linked data in Access
