Access Module 3 Crossword

3. Removing records from the table
8. Allows you to view both simple form and datasheet views
10. Rules that a user must follow when entering data
12. Reorders the records alphabetically
13. Used to locate a record quickly that satisfies some criterion
16. A field that can be computed from other fields
18. The view one uses to view, enter and update data
19. Change the database structure
20. Allows you to delete all the records satisfying some criterion
21. Criterion involves a single field but is more complex
22. Failing to enter data into a required field will generate an ______ message
25. Message will appear if a user violates a validation rule
26. A field in which a user must enter data
27. Field that must match the primary key of another table
28. Allows you to make the same change to all records satisfying some criterion
29. Without a criterion, the update applies to all ______

1. A value that Access will display before the user begins adding a record
2. Looking for records that satisfy some criteria
4. Useful when you want want to review or edit data in joined or related tables
5. Modifying the data to keep it up to date
6. Means that one record in the first table is related to, or matches, many records in the second table
7. Toggles between filtered and unfiltered displays of records
9. Fields that contain more than one value
11. Adding the results of a query to an existing table
14. Adds, deletes, or changes data in a table
15. To have only the records that satisfy the criterion appear
17. Allows the user to select from a list of values when updating the contents of the field
23. The view one uses to make design changes to the form
24. When you initially create a database, you define its ______