University of Massachusetts Boston s2

University of Massachusetts Boston

College of Management

MSIS 110: Introduction to Computers

Access Project 3: Q & A

____ 1. A foreign key is a field in one table whose values are required to match a primary key of another table.

____ 2. The property that the value in a foreign key must match another table’s primary key is called entity integrity.

____ 3. To add records using Form view, click the ______button.

a. / Insert Record / c. / Add Record
b. / New Record / d. / Append Record

____ 4. Looking for all customers located in Westport is an example of ______.

a. / Seeking / c. / searching
b. / Looking / d. / questioning

____ 5. ______are rules that a user must follow when entering data.

a. / Data rules / c. / Validation rules
b. / Edit rules / d. / Normalization rules

____ 6. A(n) ______is a value that Access will display on the screen in a particular field before the user begins adding a record.

a. / required value / c. / necessary value
b. / optional value / d. / default value

____ 7. To specify that AZ, NM, and TX are the only legal values for the State field, type ______in the Validation Rule property box in the Table window.

a. / =AZ or =NM or =TX / c. / {AZ,NM,TX}
b. / AZ, NM, TX / d. / “AZ” or “NM” or “TX”

____ 8. A field has the format > in the Format box. If you type phd in the field it will display as ______.

a. / Phd / c. / phD
b. / phd / d. / PHD

____ 9. A field has the format < in the Format box. If you type me93 in the field it will display as ______.

a. / me93 / c. / Me93
b. / ME93 / d. / mE93

____ 10. A(n) ______key is a field in one table whose values are required to match a primary key of another table.

a. / secondary / c. / foreign
b. / auxiliary / d. / matching

11. ______is the message that displays if a user violates the validation rule.

12. To specify that current due amounts must be between $0.00 and $5,000, enter ______in the Validation Rule text box for the Current Due field.

13. To specify that the only legal values for the Customer Type field are EDU, MAN, or SER, enter ______in the Validation Rule text box for the Customer Type field.

14. A field has the format > in the Format text box. If inc is typed in the field it will display as ______.

15. To order records in the Customer table by Zip code in ascending order, click the Zip Code field, and then click the ______button.