Question 1

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

Accepted Answer

A) True 
 B)False  False

Question 2

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 A

Question 3

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  True

Question 4

A common control which displays the values in a field is called a(n) ________ Box control.

Accepted Answer

The answer of A common control which displays the values...

Question 5

Because tables are often related in Access, one result is that forms can get more complex.

Accepted Answer

A) True 
 B)False

Question 6

A Combo Box allows a user to pick a combination of correct options.

Accepted Answer

A) True 
 B)False

Question 7

Match the following terms with their descriptions:
I. Group footer
II. Group header
III. Page footer
IV. Page header
V. Section
A. Displays at the top of each unique group value
B. Displays at the top of each page
C. Can be manipulated independently of other areas
D. Displays at the bottom of each page
E. Displays at the bottom of each unique group value

Accepted Answer

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

Question 8

When editing a subform, it is almost always easier to do it in what view because you can see the data as it appears in the subform?

Accepted Answer

A)  Design 
B)  Layout 
C)  Form 
D)  Report 
A)  Design 
B)  Layout 
C)  Form 
D)  Report

Question 9

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 10

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

Question 11

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 12

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 13

Match the following controls with the type of data they would contain:
I. Text box
II. Label
III. Image
IV. Calculated
V. Subform/Subreport
A. Form title
B. Picture
C. Field
D. Form or report inside of another form or report
E. Aggregated function

Accepted Answer

The answer of Match the following controls with the type...

Question 14

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 15

If you create a form based on a table with a lookup field, the lookup field becomes a(n) ________ Box control on the new form.

Accepted Answer

The answer of If you create a form based on...

Question 16

Which of the following statements is true about changing the width of sections?

Accepted Answer

A)  All sections must have the same width. 
B)  Each section can have its own width. 
C)  Each section can have its own width within the limits of the width of the form/report. 
D)  You cannot change the width of sections. 
A)  All sections must have the same width. 
B)  Each section can have its own width. 
C)  Each section can have its own width within the limits of the width of the form/report. 
D)  You cannot change the width of sections.

Question 17

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 18

When the Allow Edits property of a form is set to No, no records can be deleted.

Accepted Answer

A) True 
 B)False

Question 19

Match the following terms with their descriptions:
I. Bound control
II. Unbound control
III. Calculated control
IV. Combo Box control
V. Control
A. Not connected to a field
B. Menu of options
C. Results of an expression
D. Connected to a field
E. Object on a form or report

Accepted Answer

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

Question 20

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.

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

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

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

A common control which displays the values in a field is called a(n) ________ Box control.

Because tables are often related in Access, one result is that forms can get more complex.

A Combo Box allows a user to pick a combination of correct options.

When editing a subform, it is almost always easier to do it in what view because you can see the data as it appears in the subform?

Where does a form header appear?

Which of the following marks the top of a section?

Which of the following is not true about Combo Boxes?

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

Match the following controls with the type of data they would contain: I. Text box II. Label III. Image IV. Calculated V. Subform/Subreport A. Form title B. Picture C. Field D. Form or report inside of another form or report E. Aggregated function

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

If you create a form based on a table with a lookup field, the lookup field becomes a(n) ________ Box control on the new form.

Which of the following statements is true about changing the width of sections?

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.

When the Allow Edits property of a form is set to No, no records can be deleted.

Match the following terms with their descriptions: I. Bound control II. Unbound control III. Calculated control IV. Combo Box control V. Control A. Not connected to a field B. Menu of options C. Results of an expression D. Connected to a field E. Object on a form or report

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

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

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

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

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

A common control which displays the values in a field is called a(n) ________ Box control.

Because tables are often related in Access, one result is that forms can get more complex.

A Combo Box allows a user to pick a combination of correct options.

When editing a subform, it is almost always easier to do it in what view because you can see the data as it appears in the subform?

Where does a form header appear?

Which of the following marks the top of a section?

Which of the following is not true about Combo Boxes?

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

Match the following controls with the type of data they would contain: I. Text box II. Label III. Image IV. Calculated V. Subform/Subreport A. Form title B. Picture C. Field D. Form or report inside of another form or report E. Aggregated function

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

If you create a form based on a table with a lookup field, the lookup field becomes a(n) ________ Box control on the new form.

Which of the following statements is true about changing the width of sections?

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.

When the Allow Edits property of a form is set to No, no records can be deleted.

Match the following terms with their descriptions: I. Bound control II. Unbound control III. Calculated control IV. Combo Box control V. Control A. Not connected to a field B. Menu of options C. Results of an expression D. Connected to a field E. Object on a form or report

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

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