Question 1

A(n) ________ is a part of a form or report that can be manipulated independently from other parts.

Accepted Answer

The answer of A(n) ________ is a part of a...

Question 2

Which of the following statements is not true about sections?

Accepted Answer

A)  Forms and reports display the Detail section by default. 
B)  The Detail section cannot be turned off. 
C)  Reports display the page header/footer by default. 
D)  Forms hide the footer section by default. 
A)  Forms and reports display the Detail section by default. 
B)  The Detail section cannot be turned off. 
C)  Reports display the page header/footer by default. 
D)  Forms hide the footer section by default.

Question 3

Match the following terms with their descriptions:
I. Detail section
II. Form footer
III. Report footer
IV. Form header
V. Report header
A. Displays once at top of report
B. Where data is displayed
C. Displays once at bottom of form
D. Displays once at bottom of report
E. Displays once at top of report

Accepted Answer

The answer of Match the following terms with their descriptions:
I....

Question 4

Text box controls cannot display numeric data, currency, or dates.

Accepted Answer

A) True 
 B)False

Question 5

The tab order can be set manually if necessary.

Accepted Answer

A) True 
 B)False

Question 6

________ controls are connected to a fields on a query or table.

Accepted Answer

The answer of ________ controls are connected to a fields...

Question 7

The title of a report would be an example of a(n) ________ control.

Accepted Answer

The answer of The title of a report would be...

Question 8

If a user attempts to enter a value in a Combo Box that is not present in the table, and the Limit to List property is enabled, Access will generate a(n) ________ message.

Accepted Answer

The answer of If a user attempts to enter a...

Question 9

Which of the following statements is not true about group headers and footers?

Accepted Answer

A)  They cannot be added to forms. 
B)  You need to use caution when adding them to forms. 
C)  They appear once for each unique value in the group. 
D)  They are named after the field on which the group is based. 
A)  They cannot be added to forms. 
B)  You need to use caution when adding them to forms. 
C)  They appear once for each unique value in the group. 
D)  They are named after the field on which the group is based.

Question 10

The ________ key is often used in a form to advance from one field to another.

Accepted Answer

The answer of The ________ key is often used in...

Question 11

Match the following controls with how they would be used:
I. Page Break
II. Combo Box
III. Bound
IV. Unbound
V. Calculated
A. Simple math is one possibility
B. Is considered static
C. Is considered dynamic
D. Provide a menu of options
E. Aid in correct pagination

Accepted Answer

The answer of Match the following controls with how they...

Question 12

Access makes it obvious to a data entry user if a form is read-only.

Accepted Answer

A) True 
 B)False

Question 13

Which of the following is not a control that can be added to a form or report?

Accepted Answer

A)  Select 
B)  Page Break 
C)  Label 
D)  Image 
A)  Select 
B)  Page Break 
C)  Label 
D)  Image

Question 14

Which of the following is not true about making a table the source data for a Combo Box?

Accepted Answer

A)  It is quicker for Access to index the data. 
B)  The data is then in an easy-to-edit location. 
C)  The user can be forced to choose from only those records in the table. 
D)  New records can be added or existing records deleted very easily. 
A)  It is quicker for Access to index the data. 
B)  The data is then in an easy-to-edit location. 
C)  The user can be forced to choose from only those records in the table. 
D)  New records can be added or existing records deleted very easily.

Question 15

________ can display data, perform calculations, and add visual effects to a form or report.

Accepted Answer

The answer of ________ can display data, perform calculations, and...

Question 16

Creating a Combo Box is perfect when data ________.

Accepted Answer

A)  repeats often 
B)  is always unique 
C)  entry requires more than one answer 
D)  will not be deleted 
A)  repeats often 
B)  is always unique 
C)  entry requires more than one answer 
D)  will not be deleted

Question 17

A(n) ________ control displays the results of an expression in a form or report.

Accepted Answer

The answer of A(n) ________ control displays the results of...

Question 18

Which of the following is a recommended way of informing users that a form is read-only?

Accepted Answer

A)  Include a note in the form title. 
B)  Have a message box appear any time the form is opened. 
C)  There is no need to inform the user. 
D)  There is never a need to make a form read-only. 
A)  Include a note in the form title. 
B)  Have a message box appear any time the form is opened. 
C)  There is no need to inform the user. 
D)  There is never a need to make a form read-only.

Question 19

Combo Boxes must be created at the same time the source table is created; they cannot be converted later from text boxes.

Accepted Answer

A) True 
 B)False

Question 20

Every form or report must have at least how many controls?

Accepted Answer

A)  1 
B)  2 
C)  3 
D)  4 
A)  1 
B)  2 
C)  3 
D)  4

A(n) ________ is a part of a form or report that can be manipulated independently from other parts.

Which of the following statements is not true about sections?

Text box controls cannot display numeric data, currency, or dates.

The tab order can be set manually if necessary.

________ controls are connected to a fields on a query or table.

The title of a report would be an example of a(n) ________ control.

If a user attempts to enter a value in a Combo Box that is not present in the table, and the Limit to List property is enabled, Access will generate a(n) ________ message.

Which of the following statements is not true about group headers and footers?

The ________ key is often used in a form to advance from one field to another.

Match the following controls with how they would be used: I. Page Break II. Combo Box III. Bound IV. Unbound V. Calculated A. Simple math is one possibility B. Is considered static C. Is considered dynamic D. Provide a menu of options E. Aid in correct pagination

Access makes it obvious to a data entry user if a form is read-only.

Which of the following is not a control that can be added to a form or report?

Which of the following is not true about making a table the source data for a Combo Box?

________ can display data, perform calculations, and add visual effects to a form or report.

Creating a Combo Box is perfect when data ________.

A(n) ________ control displays the results of an expression in a form or report.

Which of the following is a recommended way of informing users that a form is read-only?

Combo Boxes must be created at the same time the source table is created; they cannot be converted later from text boxes.

Every form or report must have at least how many controls?

Introduction to Access

Tables and Queries in Relational Databases

Using Queries to Make Decisions

Creating and Using Professional Forms and Reports

Data Validation and Data Analysis

Action and Specialized Queries

Get Connected

Fine-Tuning the Database

Using Macros and Sql in Access

Microsoft Office Basics and Functions

Filters

Exam 7: Advanced Forms and Reports

A(n) ________ is a part of a form or report that can be manipulated independently from other parts.

Which of the following statements is not true about sections?

Text box controls cannot display numeric data, currency, or dates.

The tab order can be set manually if necessary.

________ controls are connected to a fields on a query or table.

The title of a report would be an example of a(n) ________ control.

If a user attempts to enter a value in a Combo Box that is not present in the table, and the Limit to List property is enabled, Access will generate a(n) ________ message.

Which of the following statements is not true about group headers and footers?

The ________ key is often used in a form to advance from one field to another.

Match the following controls with how they would be used: I. Page Break II. Combo Box III. Bound IV. Unbound V. Calculated A. Simple math is one possibility B. Is considered static C. Is considered dynamic D. Provide a menu of options E. Aid in correct pagination

Access makes it obvious to a data entry user if a form is read-only.

Which of the following is not a control that can be added to a form or report?

Which of the following is not true about making a table the source data for a Combo Box?

________ can display data, perform calculations, and add visual effects to a form or report.

Creating a Combo Box is perfect when data ________.

A(n) ________ control displays the results of an expression in a form or report.

Which of the following is a recommended way of informing users that a form is read-only?

Combo Boxes must be created at the same time the source table is created; they cannot be converted later from text boxes.

Every form or report must have at least how many controls?

Introduction to Access

Tables and Queries in Relational Databases

Using Queries to Make Decisions

Creating and Using Professional Forms and Reports

Data Validation and Data Analysis

Action and Specialized Queries

Get Connected

Fine-Tuning the Database

Using Macros and Sql in Access

Microsoft Office Basics and Functions

Filters