Question

1. You typically increase the decimal places from 1 to 2 for a(n) _____ field.

A. Currency

B. AutoNumber

C. Long Text

D. Money

2. What button do you use on the Query Tools Design tab to add a field list to a query?

A. Field List button

B. Show Table button

C. View button

D. Table Names button

3. _____ view provides the most options for defining fields.

A. Field Create

B. Field Define

C. Table Create

D. Table Design

4. In Form view, how can you navigate to the previous record in the form?

A. Click the Back button on the Home tab.

B. Click the left arrow button on the left side of the form.

C. Click the Previous record button on the navigation bar.

D. Click the Previous button in the status bar.

5. When you remove a control layout from a report, Access _____.

A. removes the controls from the report

B. changes the arrangement of the controls

C. displays an error message

D. no longer groups the controls together in the report

6. To create a banded rows effect in a report, you _____.

A. apply a table style to the report

B. set the alternate row color of a report section

C. insert a background image

D. change the column layout

7. You use the Insert Rows button on the Query Tools Design tab to _____.

nsert a row in the query design grid

B. insert a row in the selected field list

C. insert a row in the query datasheet

D. insert a new query design grid

8. To create a _____, you add the Total row to the query design grid to specify how to group and perform calculations on the records.

A. select query

B. subtotal query

C. statistics query

D. summary query

Answer 1

1)  Currency
2)  Field List button
3)  table design
4)  Click the Previous record button on the navigation bar.
5)  no longer groups the controls together in the report
6)  set the alternate row color of a report section
7)  insert a row in the query design grid
8)  summary query