Deck 7: Advanced Forms and Reports: Hands-On-Exercise Videos

Question 1

Sections can be used in reports but not in forms.

Answer 1

False

Question 2

A text box can be converted into a combo box.

Answer 2

True

Question 3

Advanced controls can be used in forms but not in reports.

Answer 3

False

Question 4

The expression IIf(IsNull([ClosedDate]),"Open","Closed")displays ________.

A) Closed when the ClosedDate field has no value and Open otherwise
B) Open when the ClosedDate field has no value and Closed otherwise
C) Closed when the ClosedDate field has no value and nothing otherwise
D) Open when the ClosedDate field has no value and nothing otherwise

Question 5

A combo box is used to display a drop-down menu containing a list of options from which users choose a single option.

Question 6

By using a ________,you can create a form that displays records from two related tables.

A) linked form
B) subordinate form
C) subform
D) mini-form

Question 7

If you want users to view a form but not make any changes to its data,you would use a ________ form.

A) protected
B) locked
C) secure
D) read-only

Question 8

You would use a ________ box control to display a drop-down menu containing a list of customer satisfaction options from which users would select one.

A) selection
B) check
C) list
D) combo

Question 9

To prevent any changes to a form,select the No option for Allow Additions,Allow Deletions,and Allow Edits in the ________.

A) Changes dialog box
B) Property Sheet
C) Protection dialog box
D) Attributes Sheet

Question 10

A locked form displays data but does not allow any changes to the data.

Question 11

Form headers or report footers are examples of form or report ________.

A) subdivisions
B) divisions
C) segments
D) sections

Question 12

You can adjust the tab order to control the advancement from one field or control to the next.