Question 1

To make sure that a user can only pick from an item on the list in a Combo Box,the ________ to List property must be enabled.

Accepted Answer

The answer of To make sure that a user can...

Question 2

A common control which displays the values in a field is called what type of control?

Accepted Answer

A) Label 
B) Field 
C) Value 
D) Text Box 
A) Label 
B) Field 
C) Value 
D) Text Box

Question 3

A form contained inside of another form is called a(n)________.

Accepted Answer

The answer of A form contained inside of another form...

Question 4

Subforms always display all the fields from the underlying table.

Accepted Answer

A) True 
 B)False

Question 5

As long as you have created the table relationships correctly,after you convert a text box to a Combo Box Access will make the appropriate connections in the Combo Box.

Accepted Answer

A) True 
 B)False

Question 6

Which of the following is not true about Combo Boxes?

Accepted Answer

A) They are not good for repetitive data. 
B) They should not be used if the menu would become too long. 
C) They can reference data in other tables. 
D) They can make data entry more reliable. 
A) They are not good for repetitive data. 
B) They should not be used if the menu would become too long. 
C) They can reference data in other tables. 
D) They can make data entry more reliable.

Question 7

Sometimes tables are created for no other purpose than to hold the values that will be used in a Combo Box.

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

A) The Delete command is not visible. 
B) The Delete command has a line through it. 
C) The Delete command is grayed out. 
D) There is no way to tell if records cannot be deleted. 
A) The Delete command is not visible. 
B) The Delete command has a line through it. 
C) The Delete command is grayed out. 
D) There is no way to tell if records cannot be deleted.

Question 9

When the Allow Edit property of a form is set to No,no new records can be added.

Accepted Answer

A) True 
 B)False

Question 10

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 11

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

Accepted Answer

The answer of A form that enables users to view...

Question 12

The reason the value displayed in fields on a form change when the data in the table changes is that the fields on a form are bound controls.

Accepted Answer

A) True 
 B)False

Question 13

What does the Label control display as a default when used in a form or report?

Accepted Answer

A) Caption set for a field if there is one 
B) Label name 
C) Default value for the field if there is one 
D) "Label" 
A) Caption set for a field if there is one 
B) Label name 
C) Default value for the field if there is one 
D) "Label"

Question 14

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

Adding which control will insure that your reports are paginated correctly?

Accepted Answer

A) Line Break 
B) Page Break 
C) Pagination 
D) Section Break 
A) Line Break 
B) Page Break 
C) Pagination 
D) Section Break

Question 17

Match between columns
                        Premises: Unbound
Combo Box
Bound
Calculated
Page Break

Accepted Answer

The Answer of Is considered dynamic and Is considered static is...

Question 18

Which of the following marks the top of a section?

Accepted Answer

A) Section divider 
B) Section line 
C) Section bar 
D) Section break 
A) Section divider 
B) Section line 
C) Section bar 
D) Section break

To make sure that a user can only pick from an item on the list in a Combo Box,the ________ to List property must be enabled.

A common control which displays the values in a field is called what type of control?

A form contained inside of another form is called a(n)________.

Subforms always display all the fields from the underlying table.

As long as you have created the table relationships correctly,after you convert a text box to a Combo Box Access will make the appropriate connections in the Combo Box.

Which of the following is not true about Combo Boxes?

Sometimes tables are created for no other purpose than to hold the values that will be used in a Combo Box.

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

When the Allow Edit property of a form is set to No,no new records can be added.

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

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

The reason the value displayed in fields on a form change when the data in the table changes is that the fields on a form are bound controls.

What does the Label control display as a default when used in a form or report?

What word would not describe an unbound control?

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.

Adding which control will insure that your reports are paginated correctly?

Which of the following marks the top of a section?

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,the ________ to List property must be enabled.

A common control which displays the values in a field is called what type of control?

A form contained inside of another form is called a(n)________.

Subforms always display all the fields from the underlying table.

As long as you have created the table relationships correctly,after you convert a text box to a Combo Box Access will make the appropriate connections in the Combo Box.

Which of the following is not true about Combo Boxes?

Sometimes tables are created for no other purpose than to hold the values that will be used in a Combo Box.

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

When the Allow Edit property of a form is set to No,no new records can be added.

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

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

The reason the value displayed in fields on a form change when the data in the table changes is that the fields on a form are bound controls.

What does the Label control display as a default when used in a form or report?

What word would not describe an unbound control?

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.

Adding which control will insure that your reports are paginated correctly?

Which of the following marks the top of a section?

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