Access Module 3 Crossword

1234567891011121314151617181920212223242526272829
Across
  1. 3. Removing records from the table
  2. 8. Allows you to view both simple form and datasheet views
  3. 10. Rules that a user must follow when entering data
  4. 12. Reorders the records alphabetically
  5. 13. Used to locate a record quickly that satisfies some criterion
  6. 16. A field that can be computed from other fields
  7. 18. The view one uses to view, enter and update data
  8. 19. Change the database structure
  9. 20. Allows you to delete all the records satisfying some criterion
  10. 21. Criterion involves a single field but is more complex
  11. 22. Failing to enter data into a required field will generate an ______ message
  12. 25. Message will appear if a user violates a validation rule
  13. 26. A field in which a user must enter data
  14. 27. Field that must match the primary key of another table
  15. 28. Allows you to make the same change to all records satisfying some criterion
  16. 29. Without a criterion, the update applies to all ______
Down
  1. 1. A value that Access will display before the user begins adding a record
  2. 2. Looking for records that satisfy some criteria
  3. 4. Useful when you want want to review or edit data in joined or related tables
  4. 5. Modifying the data to keep it up to date
  5. 6. Means that one record in the first table is related to, or matches, many records in the second table
  6. 7. Toggles between filtered and unfiltered displays of records
  7. 9. Fields that contain more than one value
  8. 11. Adding the results of a query to an existing table
  9. 14. Adds, deletes, or changes data in a table
  10. 15. To have only the records that satisfy the criterion appear
  11. 17. Allows the user to select from a list of values when updating the contents of the field
  12. 23. The view one uses to make design changes to the form
  13. 24. When you initially create a database, you define its ______