Microsoft Access Vocabulary List

123456789101112131415161718192021222324252627282930313233343536373839
Across
  1. 5. To substitute new text after finding a string of text.
  2. 6. A piece of data stored about each record in a table.
  3. 7. Built-in Access formulas.
  4. 12. From A to Z or 1 to 9.
  5. 16. A series of dialog boxes that guide you step-by-step through a process.
  6. 19. Comma-separated values
  7. 20. Information needed by a function.
  8. 23. To arrange records alphabetically or numerically according to a specific field.
  9. 25. The field that uniquely identifies each record in a table.
  10. 27. An item in an Access database, such as a table, query, form, or report.
  11. 28. Criteria that means any one criterion must be true for the statement to be true.
  12. 29. Filtering specifications that determine what records will be included in a query.
  13. 32. To add protection to a file so others cannot read it.
  14. 33. From Z to A or 9 to 1.
  15. 34. A view of data designed for lookup or input of records.
  16. 36. A comma, tab, or dash used to separate field values in a record.
  17. 37. A combination of a text box and a list.
  18. 38. To add to the end of.
Down
  1. 1. A collection of records that share the same fields.
  2. 2. Structured Query Language
  3. 3. To sort records by a particular field organized into groups.
  4. 4. Used to search for a pattern; represents any character.
  5. 8. A value in a child table that does not have a corresponding value in a parent table.
  6. 9. Criteria that means all criteria must be true for the statement to be true.
  7. 10. Not connected to a particular field.
  8. 11. An alternative name for a field.
  9. 13. Used to add subtotals and counts to a report.
  10. 14. A Microsoft Relational Database Management application.
  11. 15. To display only certain records.
  12. 17. Needed to create a calculation.
  13. 18. The order of focus when you press the TAB key.
  14. 21. Refers to enhancing the appearance of the information.
  15. 22. Copies Access information to another database, spreadsheet, or file format.
  16. 24. An organized collection of information about a subject.
  17. 26. The stored information about one particular instance.
  18. 30. Quickly copy data from an external file into an Access database.
  19. 31. Provides a temporary way to display a subset of records that match given criteria.
  20. 35. A printable layout of the data from a table or query.
  21. 39. Portable Document Format