Question 1

Changes to a subform are easier to make in Layout view.

Accepted Answer

A) True 
 B)False  True

Question 2

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

Accepted Answer

A) True 
 B)False  True

Question 3

Bound,unbound,and calculated controls are not found on the Controls group on the Design tab.

Accepted Answer

A) True 
 B)False  True

Question 4

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. 
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 5

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

Accepted Answer

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

Question 6

Subforms have to be created using the Form Wizard.

Accepted Answer

A) True 
 B)False

Question 7

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 
A)  tab order 
B)  bound control 
C)  unbound control 
D)  calculated control

Question 8

A(n)________ is a control in a form or report is not attached to any specific field in a table or query.

Accepted Answer

The answer of A(n)________ is a control in a form...

Question 9

What is the purpose of a read-only form?

Accepted Answer

A read-only form is

Question 10

What are two options for adding emphasis to your form or report?

Accepted Answer

A)  Line or rectangle control 
B)  Rectangle or calculated control 
C)  Unbound or rectangle control 
D)  Bound or unbound control 
A)  Line or rectangle control 
B)  Rectangle or calculated control 
C)  Unbound or rectangle control 
D)  Bound or unbound control

Question 11

What will cause a group to print on a separate page?

Accepted Answer

The answer of What will cause a group to print...

Question 12

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 13

Both label controls and text box controls are known as bound controls.

Accepted Answer

A) True 
 B)False

Question 14

What is the group footer used for?

Accepted Answer

A)  Totaling the data at the end of each group 
B)  Totaling the data at the end of each page 
C)  Totaling the data at the end of each section 
D)  Totaling the data at the end of the form 
A)  Totaling the data at the end of each group 
B)  Totaling the data at the end of each page 
C)  Totaling the data at the end of each section 
D)  Totaling the data at the end of the form

Question 15

Calculated controls begin with a(n):

Accepted Answer

A)  equal sign (=). 
B)  plus sign (+). 
C)  pound sign (#). 
D)  bracket ([ ]). 
A)  equal sign (=). 
B)  plus sign (+). 
C)  pound sign (#). 
D)  bracket ([ ]).

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

How can you add emphasis to a form or report?

Accepted Answer

Emphasis can be adde

Question 18

Unbound controls do not require data entry so a tab stop can be removed.

Accepted Answer

A) True 
 B)False

Question 19

An explanatory note added to a form or report is considered a label because it is not tied to a specific field.

Accepted Answer

A) True 
 B)False

Question 20

Which of the following appears at the top of each form or report?

Accepted Answer

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

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

Changes to a subform are easier to make in Layout view.

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

Bound,unbound,and calculated controls are not found on the Controls group on the Design tab.

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

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

Subforms have to be created using the Form Wizard.

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

A(n)________ is a control in a form or report is not attached to any specific field in a table or query.

What is the purpose of a read-only form?

What are two options for adding emphasis to your form or report?

What will cause a group to print on a separate page?

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

Both label controls and text box controls are known as bound controls.

What is the group footer used for?

Calculated controls begin with a(n):

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

How can you add emphasis to a form or report?

Unbound controls do not require data entry so a tab stop can be removed.

An explanatory note added to a form or report is considered a label because it is not tied to a specific field.

Which of the following appears at the top of each form or report?

Introduction to Access: Hands-On-Exercise Videos

Tables and Queries in Relational Databases: Hands-On-Exercise Videos

Customize, analyze, and Summarize Query Data: Hands-On-Exercise Videos

Creating and Using Professional Forms and Reports: Hands-On-Exercise Videos

Data Validation and Data Analysis: Hands-On-Exercise Videos

Action and Specialized Queries: Hands-On-Exercise Videos

Advanced Forms and Reports: Hands-On-Exercise Videos

Get Connected: Hands-On-Exercise Videos

Fine-Tuning the Database: Hands-On-Exercise Videos

Using Macros and SQL in Access: Hands-On-Exercise Videos

Introduction to Access: Finding Your Way Through an Access Database

Office Fundamentals and File Management: Hands-On-Exercise Videos

Office Fundamentals and File Management

Tables and Queries in Relational Databases: Designing Databases and Extracting Data

Customize, analyze, and Summarize Query Data: Creating and Using Queries to Make Decisions

Creating and Using Professional Forms and Reports: Moving Beyond Tables and Queries

Data Validation and Data Analysis: Reducing Errors and Extracting Better Information

Action and Specialized Queries: Moving Beyond the Select Query

Get Connected: Exchanging Data Between Access and Other Applications

Fine-Tuning the Database: Analyzing and Improving Database Performance

Using Macros and SQL in Access: Advanced Techniques

Filters