Microsoft Access Vocabulary List

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