1. All of the following describe a many-to-many relationship in Access EXCEPT
a) a junction table is used.
b) many matching records are found in each direction between tables.
c) may be used to connect to Oracle and other databases.
d) there must be at least four tables.
2. The term cardinality refers to
a) a count of the total records in a table.
b) a field which is a candidate for a primary key.
c) the number of records in a relationship.
d) the most important field in a table.
3. Validation text
a) changes the way text data is formatted.
b) determines the maximum length of a text field.
c) requires text data to be inputted correctly.
d) specifies the error message when a rule is violated.