Access 3 & 4 Review NP2019

12345678910111213141516
Across
  1. 1. Standard alphabetical sort order.
  2. 3. To count how many records are in a list in a query in datasheet view, click the button to add a ___ row.
  3. 5. When using the Report Wizard, you can select the __ of the report (Stepped, Outline, etc.).
  4. 6. A greater than sign is an example of a ___ operator.
  5. 8. To hide a field, ___ the Show box in the query design grid.
  6. 10. Using Filter by ___, you can highlight the first letter of a record to select all records that begin with that letter.
  7. 12. In a report, set ___ formatting to make certain fields appear differently based on set criteria.
  8. 13. This is a temporary view of data that meets specific criteria.
  9. 15. In Query Design view, the query design ___ shows you the field names, sort orders, and criteria used.
  10. 16. Compared to tables, these give you more control over how data is arranged when printed.
Down
  1. 2. You can create calculated field in a query using the ___ builder.
  2. 4. When editing a form, you can add fields in either Design view or this view.
  3. 5. If you cannot fit all data on a report, consider changing the orientation to this.
  4. 7. To replace "cocoa" with "chocolate" in any part of the field, you must click the ___ arrow in the Find and Replace dialog box.
  5. 9. You use Query Design view to add ___ to limit the number of records shown in the resulting datasheet.
  6. 11. To turn a filter off and on.
  7. 14. If you want to sort first by LastName and then by FirstName, set both fields to ascending but FirstName should be on the ___.