Maintaining the Crossword Database

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