Access_Ch04_Crossword

123456789101112
Across
  1. 1. A property for a field that, when set to Yes, forces the user to make an entry in the field for each record.
  2. 7. A key that consists of two or more fields, the unique combination of which forms the key.
  3. 9. A table that has been structured so that it conforms to 1NF, 2NF, and 3NF.
  4. 10. A normalization standard which dictates that every field must be directly dependent on the primary or composite key fields, not just indirectly dependent.
  5. 12. A macro that exists as a separate object in the database from any other table, query, form, or report.
Down
  1. 2. A feature of Access that allows you to speed up searches and sorts and can require that a field contain unique values for each record.
  2. 3. A macro that is stored in a database object, such as a table, query, form, or report.
  3. 4. A sequence of steps that are automatically performed when a specific trigger is activated.
  4. 5. A field type that enables the user to insert and store data files from other programs in the database.
  5. 6. An embedded macro.
  6. 8. A normalization standard which dictates that the table must contain no duplicate records.
  7. 11. A normalization standard which dictates that all other fields must be fully dependent on the primary key.