Across
- 7. A calculation that involves values from the fields in a single record.
- 8. A query that calculates a statistic (for example, a sum, average, or count) for data that is grouped by two different types of information; also called a crosstab.
- 11. In Access, a field used in queries that are not contained in a database, but can be computed from fields that are.
- 12. A query that displays a dialog box that prompts the user to enter one or more criteria values when the query is run.
- 15. A criterion that uses a range of values in a single field.
- 17. A wildcard character (*) that represents any collection of characters.
- 19. To copy a table or query from an Access database so that another application (such as Excel or Word) can use the data.
- 23. A file in which the width of any field is the same on every record.
- 24. Criteria placed in the same row of the query design grid; all criteria in the same row must be true for a record to appear on the data sheet.
- 29. A window that displays an exhaustive list of properties for the chosen control, section, or object on a form or report.
- 30. In Access, the more important field in a sort; also called a primary key sort.
- 31. A symbol that indicates the relationship between two values.
- 33. In Access, data in a field whose data type is Short Text.
- 34. Criterion or query formed by connecting two or more simple criteria using AND, OR, and NOT.
Down
- 1. A separator such as a space, comma, or semicolon between elements in imported data.
- 2. A special symbol that substitutes for unknown characters in search text; the most common are the question mark (?), which stands for any single character, and the asterisk (*), which represents any group of characters.
- 3. The field or fields on which records are sorted in a query.
- 4. Properties that indicate which records appear in a join.
- 5. A less important field in a sort; also called a secondary sort key.
- 6. A calculation performed on a group of records rather than on an individual record.
- 9. To organize data, such as table rows, items in a list, or records in a mail merge, in ascending or descending order, based on criteria such as date, alphabetical order, file size, or filename.
- 10. In Access, a less important field in a sort; also called a minor key.
- 13. In Office apps and in Windows, a section of a tab on the ribbon containing related commands.
- 14. In Access, a criterion that allows you select values in a given range.
- 16. A function, such as Sum or Avg, that performs an arithmetic operation on selected records in a database.
- 18. A query that lets you restrict the number of records that appear.
- 20. The more important field in a sort; also called the major key.
- 21. To relate tables using a common field.
- 22. Criteria placed on different rows of the query design grid; a record will be selected for the resulting datasheet if it is true for any single row.
- 25. In Access, a criterion that lets you select a list of values.
- 26. A wildcard that represents any individual character in a search.
- 27. The line identifying which fields establish the relationship between two related tables; also called a link line.
- 28. A field used in a query that is not contained in a database, but can be computed from fields that are.
- 32. A file in which each record is on a separate line and the fields are separated by a special character, called the delimiter.