Question 1

It is possible to set up restrictions which allow records to be added, but not deleted using a form.

Accepted Answer

A) True 
 B)False

Question 2

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 3

Subforms always display all the fields from the underlying table.

Accepted Answer

A) True 
 B)False

Question 4

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 5

A tab stop should always be set for AutoNumber fields.

Accepted Answer

A) True 
 B)False

Question 6

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 7

It is possible to set up restrictions which allow records to be deleted, but not added using a form.

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

________ can be created from tables, queries, or existing forms.

Accepted Answer

The answer of ________ can be created from tables, queries,...

Question 10

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 11

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 12

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 13

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 14

________ controls are dynamic.

Accepted Answer

The answer of ________ controls are dynamic....

Question 15

What key is often used in a form to advance from one field to another?

Accepted Answer

A)  Right Arrow key 
B)  Shift Tab 
C)  Space bar 
D)  Tab 
A)  Right Arrow key 
B)  Shift Tab 
C)  Space bar 
D)  Tab

Question 16

What happens to the controls in a section if you turn off the section?

Accepted Answer

A)  All controls in that section are minimized. 
B)  All controls in that section are moved to the next higher section. 
C)  All controls in that section are deleted. 
D)  All controls in that section are hidden. 
A)  All controls in that section are minimized. 
B)  All controls in that section are moved to the next higher section. 
C)  All controls in that section are deleted. 
D)  All controls in that section are hidden.

Question 17

If two tables are related and you use the Form Wizard, a subform will automatically be created in the main form.

Accepted Answer

A) True 
 B)False

Question 18

Which of the following is not true about what restrictions can be set for a form?

Accepted Answer

A)  A user cannot delete a record. 
B)  A user cannot view a record. 
C)  A user cannot add a record. 
D)  A user cannot change a record. 
A)  A user cannot delete a record. 
B)  A user cannot view a record. 
C)  A user cannot add a record. 
D)  A user cannot change a record.

Question 19

In what section is the field which calculates the total number of pages in the document, normally put?

Accepted Answer

A)  Report header 
B)  Report footer 
C)  Page header 
D)  Page footer 
A)  Report header 
B)  Report footer 
C)  Page header 
D)  Page footer

Question 20

When you are creating a subform, you can use existing tables and queries or you can use an existing ________.

Accepted Answer

The answer of When you are creating a subform, you...

It is possible to set up restrictions which allow records to be added, but not deleted using a form.

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

Subforms always display all the fields from the underlying table.

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

A tab stop should always be set for AutoNumber fields.

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.

It is possible to set up restrictions which allow records to be deleted, but not added using a form.

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

________ can be created from tables, queries, or existing forms.

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

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.

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

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.

________ controls are dynamic.

What key is often used in a form to advance from one field to another?

What happens to the controls in a section if you turn off the section?

If two tables are related and you use the Form Wizard, a subform will automatically be created in the main form.

Which of the following is not true about what restrictions can be set for a form?

In what section is the field which calculates the total number of pages in the document, normally put?

When you are creating a subform, you can use existing tables and queries or you can use an existing ________.

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

It is possible to set up restrictions which allow records to be added, but not deleted using a form.

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

Subforms always display all the fields from the underlying table.

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

A tab stop should always be set for AutoNumber fields.

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.

It is possible to set up restrictions which allow records to be deleted, but not added using a form.

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

________ can be created from tables, queries, or existing forms.

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

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.

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

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.

________ controls are dynamic.

What key is often used in a form to advance from one field to another?

What happens to the controls in a section if you turn off the section?

If two tables are related and you use the Form Wizard, a subform will automatically be created in the main form.

Which of the following is not true about what restrictions can be set for a form?

In what section is the field which calculates the total number of pages in the document, normally put?

When you are creating a subform, you can use existing tables and queries or you can use an existing ________.

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