Access Forms & Reports:
Quiz

 Title: Jan's Illustrated Computer Literacy 101
Did you want: Working with Databases: Access 2007, 2010, 2013, 2016

For each question, click on Radio Button 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.

Choose the BEST answer. 

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

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

   a.

   b.

   c. choice c

   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 | Options | Forms & Reports

 c. Tools | Options | Forms & Reports

 d. none of the above

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

   a. Can Grow = Yes

   b. Can Shrink = Yes

   c. Size = To Fit

 d. Expand = Yes

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

 a. Grp Hdr/Ftr = Yes, in the report's Properties dialog

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

  c. Group Header = Yes, in the Sorting and Grouping dialog

 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 Properties dialog

   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