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