Question 1

To make sure that a user can only pick from an item on the list in a Combo Box, what property must be enabled?

Accepted Answer

A)  Limit to List 
B)  Restrict to List 
C)  Limit to Menu 
D)  Restrict to Menu 
A)  Limit to List 
B)  Restrict to List 
C)  Limit to Menu 
D)  Restrict to Menu

Question 2

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

Accepted Answer

The answer of The ________ order is the sequential advancing...

Question 3

What is one way the user can tell that new records cannot be created in a form?

Accepted Answer

A)  The New command is grayed out. 
B)  The New command is removed. 
C)  The New command has a line through it. 
D)  There is no way to tell that new records cannot be created. 
A)  The New command is grayed out. 
B)  The New command is removed. 
C)  The New command has a line through it. 
D)  There is no way to tell that new records cannot be created.

Question 4

Match the following terms with their descriptions:
I. Read-only form
II. Section bar
III. Subform
IV. Tab order
V. Control
A. Can be viewed, but not changed
B. Sequential order of fields
C. Marks top of a section
D. Object on a form or report
E. Usually displayed in tabular fashion

Accepted Answer

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

Question 5

A form that enables users to view but not change data is a(n) ________ form.

Accepted Answer

read-only,

Question 6

The controls toolbar will tell you if a control is a bound or unbound control.

Accepted Answer

A) True 
 B)False

Question 7

Combo Boxes must be created at the same time the source table is created.

Accepted Answer

A) True 
 B)False

Question 8

The tab order can be set manually if necessary.

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

Where does a form header appear?

Accepted Answer

A)  At the top of each page 
B)  At the left of each page 
C)  Once, at the left of the form 
D)  Once, at the top of the form 
A)  At the top of each page 
B)  At the left of each page 
C)  Once, at the left of the form 
D)  Once, at the top of the form

Question 11

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 12

________ controls are not connected to fields in a table or query.

Accepted Answer

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

Question 13

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 14

What is the name of the section that displays the data in a form or report?

Accepted Answer

A)  Footer 
B)  Header 
C)  Detail 
D)  Content 
A)  Footer 
B)  Header 
C)  Detail 
D)  Content

Question 15

What word would not describe an unbound control?

Accepted Answer

A)  Static 
B)  Unchanging 
C)  Dynamic 
D)  Decorative 
A)  Static 
B)  Unchanging 
C)  Dynamic 
D)  Decorative

Question 16

Subforms are generally laid out in a(n) ________ fashion.

Accepted Answer

The answer of Subforms are generally laid out in a(n)...

Question 17

Page headers and footers are turned off by default in forms.

Accepted Answer

A) True 
 B)False

Question 18

If you had a five-page report, which of the following statements is true?

Accepted Answer

A)  The form header and/or footer would display twice; one on the first page and one on the last page. 
B)  The page header and/or footer would display twice; one on the first page and one on the last page. 
C)  The form header and/or footer would display five times. 
D)  The page header and/or footer would display five times. 
A)  The form header and/or footer would display twice; one on the first page and one on the last page. 
B)  The page header and/or footer would display twice; one on the first page and one on the last page. 
C)  The form header and/or footer would display five times. 
D)  The page header and/or footer would display five times.

To make sure that a user can only pick from an item on the list in a Combo Box, what property must be enabled?

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

What is one way the user can tell that new records cannot be created in a form?

Match the following terms with their descriptions: I. Read-only form II. Section bar III. Subform IV. Tab order V. Control A. Can be viewed, but not changed B. Sequential order of fields C. Marks top of a section D. Object on a form or report E. Usually displayed in tabular fashion

A form that enables users to view but not change data is a(n) ________ form.

The controls toolbar will tell you if a control is a bound or unbound control.

Combo Boxes must be created at the same time the source table is created.

The tab order can be set manually if necessary.

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

Where does a form header appear?

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

________ controls are not connected to fields in a table or query.

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

What is the name of the section that displays the data in a form or report?

What word would not describe an unbound control?

Subforms are generally laid out in a(n) ________ fashion.

Page headers and footers are turned off by default in forms.

If you had a five-page report, which of the following statements is true?

Office 365 Common Features

Introduction to Access

Tables and Queries in Relational Databases

Query Calculations and Expressions

Basic Forms and Reports

Data Validation and Data Analysis

Action and Specialized Queries

Get Connected

Fine-Tuning the Database

Enhanced Database Techniques

Filters

Exam 8: Advanced Forms and Reports

To make sure that a user can only pick from an item on the list in a Combo Box, what property must be enabled?

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

What is one way the user can tell that new records cannot be created in a form?

Match the following terms with their descriptions: I. Read-only form II. Section bar III. Subform IV. Tab order V. Control A. Can be viewed, but not changed B. Sequential order of fields C. Marks top of a section D. Object on a form or report E. Usually displayed in tabular fashion

A form that enables users to view but not change data is a(n) ________ form.

The controls toolbar will tell you if a control is a bound or unbound control.

Combo Boxes must be created at the same time the source table is created.

The tab order can be set manually if necessary.

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

Where does a form header appear?

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

________ controls are not connected to fields in a table or query.

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

What is the name of the section that displays the data in a form or report?

What word would not describe an unbound control?

Subforms are generally laid out in a(n) ________ fashion.

Page headers and footers are turned off by default in forms.

If you had a five-page report, which of the following statements is true?

Office 365 Common Features

Introduction to Access

Tables and Queries in Relational Databases

Query Calculations and Expressions

Basic Forms and Reports

Data Validation and Data Analysis

Action and Specialized Queries

Get Connected

Fine-Tuning the Database

Enhanced Database Techniques

Filters