TEST BANK ENHANCED MICROSOFT ACCESS 2013 COMPREHENSIVE 1ST EDITION BY PRATT

1. ____ shows the report on the screen but also allows you to make changes to the report.

  a.  Print Preview b.  Layout view

  c.  Report view d.  Design view

ANSWER:   b

POINTS:   1

REFERENCES:   AC 207

2. ____ shows the report as it will appear when printed.

  a.  Report view b.  Layout view

  c.  Design view d.  Print Preview

ANSWER:   d

POINTS:   1

REFERENCES:   AC 207

3. To specify grouping and sorting for a report, tap or click the ____ button on the DESIGN tab in Layout view.

  a.  Group b.  Sort

  c.  Organize by Group d.  Group & Sort

ANSWER:   d

POINTS:   1

REFERENCES:   AC 208

4. In the accompanying figure, you can tap or click the More button in the Group, Sort, and Total pane to specify additional options. The ____ option allows you to choose the length of the value on which to group.

  a.  Length b.  Group Length

  c.  Value d.  Restrict

ANSWER:   c

POINTS:   1

REFERENCES:   AC 211

5. In the accompanying figure, you can tap or click the More button in the Group, Sort, and Total pane to specify additional options. The ____ option allows you to choose values to be totaled and where they are to appear.

  a.  Aggregate b.  Totals

  c.  Group Totals d.  Sum

ANSWER:   b

POINTS:   1

REFERENCES:   AC 211

6. In the accompanying figure, you can tap or click the More button in the Group, Sort, and Total pane to specify additional options. The ____ option allows you to customize the group title.

  a.  Customize b.  Header

  c.  Title d.  Label

ANSWER:   c

POINTS:   1

REFERENCES:   AC 211

7. In the accompanying figure, you can tap or click the More button in the Group, Sort, and Total pane to specify additional options. The ____ option allows you to indicate whether Access is to attempt to keep portions of a group together on a page.

  a.  Same Page b.  Keep together

  c.  Page Group d.  No Orphans

ANSWER:   b

POINTS:   1

REFERENCES:   AC 211

8. In the accompanying figure, ____ are used to display data that comes for the database, such as the customer number and name.

  a.  Bound controls b.  Unbound controls

  c.  Calculated controls d.  Aggregate controls

ANSWER:   a

POINTS:   1

REFERENCES:   AC 211

9. ____ are not associated with data from the database and are used to display such things as the report’s title.

  a.  Bound controls b.  Unbound controls

  c.  Title controls d.  Calculated controls

ANSWER:   b

POINTS:   1

REFERENCES:   AC 211

10. ____ are used to display data that is calculated from other data, such as a total.

  a.  Unbound controls b.  Bound controls

  c.  Calculated controls d.  Aggregate controls

ANSWER:   c

POINTS:   1

REFERENCES:   AC 211