1. (TCO 2) To create a relationship between two tables, you need at least a (Points : 4)

data type. query. hyperlink. primary key.

2. (TCO 2) Which of the following does NOT describe a many-to-many relationship? (Points : 4)

There must be at least two tables. Many matching records exist in each direction between the tables. A junction table is used. You can connect to tables in other databases such as Oracle.

3. (TCO 2) Primary keys can be created (Points : 4)

as computer-generated fields. from an existing single field. from several existing fields. All of the above

4. (TCO 3) A relational table includes the following conditions EXCEPT (Points : 4)

column entries and attributes must be the same data type. rows must be in order. cells contain a single data value. columns or attributes have a well defined range of values.

5. (TCO 3) Which of the following is true regarding the use of delimiters in a field criterion in Access? (Points : 4)

Date/Time data types need no delimiters. Date/Time data types need to be enclosed in single quotes. Number data types require no delimiters. Text data types require pound signs.

6. (TCO 3) The field property that ensures that the field is not empty is (Points : 4)

Format. Required. Validation. Validation Rule.

7. (TCO 3) All of the following are true about a property EXCEPT (Points : 4)

a Datasheet View is used to display properties. referenced as an attribute. changes can be made with a property sheet. tables, forms, queries, and reports can have properties.

8. (TCO 4) Which of the following is NOT an example of a primary key? (Points : 4)

ISBN number for a textbook Last name Social Security Number Student ID

9. (TCO 4) To ensure that a value of 15 or greater was entered into a field, you would use a (Points : 4)

field size. field type. Sarbanes-Oxley Act. validation rule.

10. (TCO 2) Which of the following is a property that determines how much physical storage the field requires in the database? (Points : 4)

Caption Field Size Input Mask Validation Rule