Quiz: Forms & Reports | Jan's Working with Databases

For each question, click on

the radio button for your answer. You will be notified immediately whether your choice is correct or not. Double clicking may work better in some browsers.

1. When Access does not contain a table of data but reaches out to another source for the data, that table is _____.

a. embedded

b. linked

c. an accessory table

d. a subdatasheet

Selection 2. If controls are selected as shown in the illustration at the right and you choose Align > Left, which choice below shows what happens?

a. Choice a

b. Choice b

c. choice c

d. Choice d

3. You drag on a form in Form Design View and only the controls that you completely enclosed were selected. To change this behavior so that you can select controls that are just partly enclosed by your dragging, you must go to ____.

a. Tools > Customize > Forms & Reports

b. File tab or Office Button > Options > Forms & Reports

c. Tools > Options > Forms & Reports

d. none of the above

4. The property and value in the Property Sheet that will allow a control to get larger if it needs more space is _____.

a. CanGrow = Yes

b. CanShrink = Yes

c. Size = To Fit

d. Expand = Yes

5. To see a group header on a report, you can choose ____.

a. Display = Always in Property Sheet for the group section

b. Group Header/Group Footer = Yes, in the Property Sheet for the group's section

c. 'with a header section' in the 'Group on' entry in the Group, Sort, and Total pane

d. any of the above

6. To show the total of the Price values for a group of records, you need a calculated control that uses the expression _____ as its source.

a. Sum[Price]

b. Sum([Price])

c. =Sum[Price]

d . = Sum([Price])

7. A total over the whole report that is calculated without using Visual Basic code can be placed in ____.

a. the Report Header, Report Footer, Page Header or Page Footer

b. the Report or Page Footer only

c. the Report Footer only

d. the Report Header or Report Footer only

8. A form has a subform that is in the Detail section. For the subform to show only the records that match the current record, you must choose matching fields in the properties ____.

a. Link Child Fields and Link Parent Fields in the form's Properties

b. Link Child Fields and Link Master Fields in the form's Properties

c. Link Child Fields and Link Parent Fields in the subform's Properties

d. Link Child Fields and Link Master Fields in the subform's Properties

e. any of the above

9. To make a report show its records in columns, you must make changes in ____.

a the report's Property Sheet

b. the Page Setup dialog

c. the Options dialog

d. none of the above

10. Your report or form does not show all of the data that should show in a particular control. You can ensure that the data all shows by changing ____.

a. the control's Can Grow property to Yes

b. the control's Can Grow property to Yes and the Detail section's Can Grow property to Yes.

c. the control's Can Grow/Can Shrink property to Yes and the Detail section's Can Grow/Can Shrink property to Yes.

d. the control's type to Memo

e. none of the above

Jan's Working with Databases

Forms & Reports: Quiz