ACA Access Databases 3-4

Edit Answers
123456789101112131415161718192021
Across
  1. 1. To select both a field label and field value to move in a report design, after selecting the field label, press this key to select the field value box.
  2. 3. To add a row labeled "Total" to a query design, click the __ button in the Show/Hide group on the DESIGN tab on the Ribbon.
  3. 5. Print All, Pages, and Selected Record(s) are options available from the Print dialog box for printing these.
  4. 8. Queries based on more than one table must have a ___ field.
  5. 10. Order from highest to lowest.
  6. 14. The comparison operator <> is used to insert a condition that means _______ to (if more than one word, combine as one word).
  7. 15. This aggregate function would be used to identify how many are marked "yes" in a Yes/No field data type.
  8. 16. This view must be used to delete an entire record from a table.
  9. 19. To edit a form in Design View to set format for a field, use the __ sheet.
  10. 21. In addition to standard colors, the font color gallery displays these colors.
Down
  1. 1. The appearance of fields in a report created using the Wizard is determined by the order the fields are ____ in the wizard.
  2. 2. To resize an image without changing its proportions, simply drag the ___ of the image.
  3. 4. A to Z order or "regular" alphabetic order.
  4. 6. Results of a query may be viewed at any time by clicking the __ button in the Results group on the Ribbon.
  5. 7. This type of field created in a query generates results when the query is run.
  6. 9. This aggregate function would be used to calculate the lowest field value for the selected records.
  7. 11. A report formatted where the page is taller than it is wide.
  8. 12. This criterion <=100 will query for values ____than or equal to 100.
  9. 13. To create calculated fields in a query, it's helpful to use the Expression ___.
  10. 17. Putting query criterion text in quotation marks will provide a/an ___ match.
  11. 18. To edit a field caption object that is not fully displayed, just ___ the object.
  12. 20. Assume "ready to adopt" is a yes/no field. What is the query value criteria for animals that are ready to be adopted?