Question 1

Adding a(n) ________ Break control can insure that your report is paginated correctly.

Accepted Answer

Page

Question 2

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

E, A, D, B, C

Question 3

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 C

Question 4

A graphic line can be considered a form control.

Accepted Answer

A) True 
 B)False

Question 5

Where do you typically put a page break?

Accepted Answer

A)  Page footer 
B)  Group footer 
C)  Group header 
D)  Section footer 
A)  Page footer 
B)  Group footer 
C)  Group header 
D)  Section footer

Question 6

How does a Combo Box control appear to a user?

Accepted Answer

A)  Menu of options 
B)  Option button 
C)  Check Box 
D)  Legacy control 
A)  Menu of options 
B)  Option button 
C)  Check Box 
D)  Legacy control

Question 7

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 8

When setting up a Combo Box, what property is used to pick the field in the table which will be used to generate the menu?

Accepted Answer

A)  Row Source 
B)  Column Source 
C)  Field Source 
D)  Record Source 
A)  Row Source 
B)  Column Source 
C)  Field Source 
D)  Record Source

Question 9

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 10

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 11

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 12

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 13

If a control is considered non-data-related, then it is a(n) ________ control.

Accepted Answer

The answer of If a control is considered non-data-related, then...

Question 14

Unbound controls are connected to specific fields in a table or query.

Accepted Answer

A) True 
 B)False

Question 15

What type of control is created if you create a form based on a table with a lookup field?

Accepted Answer

A)  Check Box 
B)  Option button 
C)  Combo Box 
D)  Lookup Box 
A)  Check Box 
B)  Option button 
C)  Combo Box 
D)  Lookup Box

Question 16

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 17

________ controls are dynamic.

Accepted Answer

The answer of ________ controls are dynamic....

Question 18

Subforms always display all the fields from the underlying table.

Accepted Answer

A) True 
 B)False

Question 19

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 20

How does Access let you know that a form is set as read-only?

Accepted Answer

A)  A notice will appear on the Status Bar while the form is open. 
B)  A pop-up message will appear when the form is opened. 
C)  The form fields will be grayed out. 
D)  No indication is given that a form is read-only. 
A)  A notice will appear on the Status Bar while the form is open. 
B)  A pop-up message will appear when the form is opened. 
C)  The form fields will be grayed out. 
D)  No indication is given that a form is read-only.

Adding a(n) ________ Break control can insure that your report is paginated correctly.

Which of the following marks the top of a section?

A graphic line can be considered a form control.

Where do you typically put a page break?

How does a Combo Box control appear to a user?

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

When setting up a Combo Box, what property is used to pick the field in the table which will be used to generate the menu?

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

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

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.

If a control is considered non-data-related, then it is a(n) ________ control.

Unbound controls are connected to specific fields in a table or query.

What type of control is created if you create a form based on a table with a lookup field?

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

________ controls are dynamic.

Subforms always display all the fields from the underlying table.

Creating a Combo Box is perfect when data ________.

How does Access let you know that a form is set as read-only?

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

Adding a(n) ________ Break control can insure that your report is paginated correctly.

Which of the following marks the top of a section?

A graphic line can be considered a form control.

Where do you typically put a page break?

How does a Combo Box control appear to a user?

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

When setting up a Combo Box, what property is used to pick the field in the table which will be used to generate the menu?

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

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

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.

If a control is considered non-data-related, then it is a(n) ________ control.

Unbound controls are connected to specific fields in a table or query.

What type of control is created if you create a form based on a table with a lookup field?

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

________ controls are dynamic.

Subforms always display all the fields from the underlying table.

Creating a Combo Box is perfect when data ________.

How does Access let you know that a form is set as read-only?

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