Across
- 2. A calculation that involves values from the fields in a single record
- 4. 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
- 6. A separator such as a space, comma, or semicolon between elements in imported data
- 8. A query that lets you restrict the number of records that appear
- 9. In Access, data in a field whose data type is Short Text
- 11. 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
- 17. A symbol that indicates the relationship between two values
- 20. In Access, a criterion that lets you select a list of values
- 22. Criterion or query formed by connecting two or more simple criteria using AND, OR, and NOT
- 23. A wildcard character (*) that represents any collection of characters
- 26. A file in which each record is on a separate line and the fields are separated by a special character, called the delimiter
- 27. 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
- 28. To copy a table or query from an Access database so that another application (such as Excel or Word) can use the data
- 29. To relate tables using a common field
- 30. Properties that indicate which records appear in a join
- 32. 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
- 33. A wildcard that represents any individual character in a search
Down
- 1. In Access, a less important field in a sort; also called a minor key
- 3. 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 datasheet
- 5. In Access, a criterion that allows you select values in a given range
- 7. The more important field in a sort; also called the major key
- 10. A function, such as Sum or Avg, that performs an arithmetic operation on selected records in a database
- 12. A field used in a query that is not contained in a database, but can be computed from fields that are
- 13. A calculation performed on a group of records rather than on an individual record
- 14. The line identifying which fields establish the relationship between two related tables; also called a link line
- 15. In Access, the more important field in a sort; also called a primary sort key
- 16. A criterion that uses a range of values in a single field
- 18. The field or fields on which records are sorted in a query
- 19. A file in which the width of any field is the same on every record
- 21. A query that displays a dialog box that prompts the user to enter one or more criteria values when the query is run
- 22. In Access, a field used in queries that are not contained in a database, but can be computed from fields that are
- 24. A window that displays an exhaustive list of properties for the chosen control, section, or object on a form or report
- 25. A less important field in a sort; also called a secondary sort key
- 31. In Office apps and in Windows, a section of a tab on the ribbon containing related commands