Maintaining the Crossword Database

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