Question 1

Which of the following generally refers to decorative elements such as the title of a report?

Accepted Answer

A) Unbound control 
B) Bound control 
C) Calculated control 
D) Text box

Question 2

What is a subform?

Accepted Answer

The answer of What is a subform?...

Question 3

A page footer appears at the bottom of the last page of a form or report.

Accepted Answer

A) True 
 B)False

Question 4

Match between columns
                        Premises: read-only form
calculated control
bound control
tab order
unbound control

Accepted Answer

The Answer of a control that is connected to a is...

Question 5

To move a text box label,what action must you take?

Accepted Answer

A) Click the Tabular Layout in the Table group of the Arrange tab while both the label and text box controls are selected. 
B) Click the Tabular Layout in the Arrange group when the label is selected. 
C) Click the Tabular Layout in the Arrange group when the text box is selected. 
D) Click the Tabular Layout in the Arrange group of the Table group while the label and text box are selected.

Question 6

The ________ section in a report repeats for each record in a record source.

Accepted Answer

The answer of The ________ section in a report repeats...

Question 7

If you would like to see subtotals in a report,you would add a(n)________ in the Grouping footer section.

Accepted Answer

The answer of If you would like to see subtotals...

Question 8

Both forms and reports have a text box control,which displays the data found in the record source.

Accepted Answer

A) True 
 B)False

Question 9

Which of the following marks the top boundary of a section in a form or report?

Accepted Answer

A) Section bar 
B) Tab bar 
C) Bound control 
D) Unbound control

Question 10

In which section of a form or report is a company logo usually added?

Accepted Answer

The answer of In which section of a form or...

Question 11

Tab order cannot be changed in a form once it has been created.

Accepted Answer

A) True 
 B)False

Question 12

Subforms have to be created using the Form Wizard.

Accepted Answer

A) True 
 B)False

Question 13

Forms and reports based on a query can display calculated fields like any other field.

Accepted Answer

A) True 
 B)False

Question 14

Unbound controls are controls that are tied to specific fields.

Accepted Answer

A) True 
 B)False

Question 15

If you create a form based on a table with a lookup field,the lookup field becomes a combo box control on the new form.

Accepted Answer

A) True 
 B)False

Question 16

The ________ is the sequential advancing in a form from one field to the next.

Accepted Answer

A) tab order 
B) bound control 
C) unbound control 
D) calculated control

Question 17

Which of the following appears once at the bottom of each page in a form or report?

Accepted Answer

A) Form or Report Page Footer 
B) Form or Report Footer 
C) Form or Report Page Header 
D) Form or Report Header

Question 18

If no caption has been set for a field,the label will default to the field name.

Accepted Answer

A) True 
 B)False

Question 19

When creating a form or report,you can insert an image file containing the company logo.

Accepted Answer

A) True 
 B)False

Question 20

A read-only form is a form that enables users to view but not change data.

Accepted Answer

A) True 
 B)False

Exam 22: Advanced Forms and Reports: Moving Beyond the Basics

Which of the following generally refers to decorative elements such as the title of a report?

What is a subform?

A page footer appears at the bottom of the last page of a form or report.

Match the following terms with their meanings:

To move a text box label,what action must you take?

The ________ section in a report repeats for each record in a record source.

If you would like to see subtotals in a report,you would add a(n)________ in the Grouping footer section.

Both forms and reports have a text box control,which displays the data found in the record source.

Which of the following marks the top boundary of a section in a form or report?

In which section of a form or report is a company logo usually added?

Tab order cannot be changed in a form once it has been created.

Subforms have to be created using the Form Wizard.

Forms and reports based on a query can display calculated fields like any other field.

Unbound controls are controls that are tied to specific fields.

If you create a form based on a table with a lookup field,the lookup field becomes a combo box control on the new form.

The ________ is the sequential advancing in a form from one field to the next.

Which of the following appears once at the bottom of each page in a form or report?

If no caption has been set for a field,the label will default to the field name.

When creating a form or report,you can insert an image file containing the company logo.

A read-only form is a form that enables users to view but not change data.