Microsoft Access Vocabulary List

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