Access Module 2 Crossword

Edit Answers
123456789101112131415161718192021222324252627282930
Across
  1. 4. Creating groups of records that share something in common
  2. 11. Data in a field whose data type is Short Text
  3. 13. Formatted document with fields that contain data
  4. 14. Performs mathematical function on a group of records
  5. 15. Used for criterion involving a range of values in a single field
  6. 17. Used to select values in a list
  7. 20. Query that prompts for input whenever it is used
  8. 21. Primary view option to create queries
  9. 23. Properties that indicate which records appear in a join
  10. 25. To order the records in a query result in a particular way
  11. 26. Field(s) on which the records are sorted
  12. 28. Less important sort key
  13. 29. Wildcard represents any collection of characters
  14. 30. Line between matching fields in two tables
Down
  1. 1. A field that can be computed from other fields
  2. 2. Represents any individual charcter
  3. 3. Calculates a statistic for data that is grouped by two different types of information
  4. 5. Created using the words AND or OR
  5. 6. In _____, each record is on a separate line and the fields are separated by a delimiter
  6. 7. Prompt for the user
  7. 8. Indicates when text does not have to match value in the column
  8. 9. More important sort field
  9. 10. Allows you to restrict the number of records that appear
  10. 12. Criterion is true provided either individual criterion is true
  11. 16. A question presented in a way that Access can process
  12. 18. Join type; Shows one table's records and common records
  13. 19. A window containing the various properties of the object
  14. 22. Symbols that represent any character or combination of characters
  15. 24. Join type; Two tables with identical values in matching fields
  16. 27. Copying Access data for use in other applications