Maintaining the Crossword Database

1234567891011121314151617181920212223242526272829
Across
  1. 1. affects the way data appears in a field
  2. 3. when updating field contents, allows user to select from a list of values
  3. 5. also allowable values, the only values that are allowed in a field after validation rules have been applied
  4. 6. a field in which the user MUST enter data
  5. 9. tool that is used to filter individual fields, such as accounts starting with the letter 'A'
  6. 14. property that ensures that the value in a foreign key must match that of another field's primary key
  7. 16. form that allows viewing of simple and datasheet views simultaneously
  8. 18. used to add results of a query to an existing table
  9. 19. also a computed field, is a field that can be computed using other fields
  10. 21. a record in one table matches many records in another table
  11. 23. the assigned names and types of all fields when a database is initially created
  12. 26. adjusting the database by adding fields, changing field characteristics, or removing fields
  13. 27. the message that appears if a user attempts to violate the validation rules
  14. 29. allows you to remove all records that satisfy a certain criterion
Down
  1. 2. fields that can contain more than one value
  2. 4. used to add results of a query to a new table
  3. 7. allow change of a record and then make the corresponding changes in the foreign key of all related records
  4. 8. rules that a user must follow when entering data
  5. 10. keeping data up to date by modifying it
  6. 11. certain tool which can be restricted by validation rules; "must be between..."
  7. 12. field in one table whose values are required to match the primary key of another table
  8. 13. tool that only shows the record or records that satisfy certain criterion
  9. 15. allowing deletion of a record and then deleting all related records
  10. 17. query that adds, deletes, or changes data in a table
  11. 20. symbol used for a specific format in a field's property box
  12. 22. allows you to make the same change to all records satisfying a certain criterion
  13. 24. used when you want to review or edit data in joined or related tables, availability is indicated by a plus sign
  14. 25. a value that Access will display on the screen in a particular field before a record is added
  15. 28. looking for records that satisfy some criteria