Question 1

On a form, what type of control provides a drop-down menu displaying a list of options from which the user can choose a single value?

Accepted Answer

A)  Combo box 
B)  Calculated 
C)  Unbound 
D)  Bound 
A)  Combo box 
B)  Calculated 
C)  Unbound 
D)  Bound

Question 2

Which of the following fields is an example of a field that would not require a tab stop?

Accepted Answer

A)  Calculated field 
B)  Last Name field 
C)  Address field 
D)  State field 
A)  Calculated field 
B)  Last Name field 
C)  Address field 
D)  State field

Question 3

You can adjust the tab order to control the advancement from one field or control to the next.

Accepted Answer

A) True 
 B)False

Question 4

Which of the following displays when you insert a text box?

Accepted Answer

A)  Label control 
B)  Text box control 
C)  Design view control 
D)  Section control 
A)  Label control 
B)  Text box control 
C)  Design view control 
D)  Section control

Question 5

What is the purpose of a read-only form?

Accepted Answer

A read-only form is

Question 6

A page footer appears at the bottom of the last page of a form or report.

Accepted Answer

A) True 
 B)False

Question 7

By using a ________, you can create a form that displays records from two related tables.

Accepted Answer

A)  linked form 
B)  subordinate form 
C)  subform 
D)  mini-form 
A)  linked form 
B)  subordinate form 
C)  subform 
D)  mini-form

Question 8

A calculated control contains an expression that generates a calculated result.

Accepted Answer

A) True 
 B)False

Question 9

Where is the Page Header located?

Accepted Answer

A)  Top of each page 
B)  Top of form/report 
C)  At the end of each group 
D)  Bottom of each page 
A)  Top of each page 
B)  Top of form/report 
C)  At the end of each group 
D)  Bottom of each page

Question 10

How do you switch on or off sections of a report or form?

Accepted Answer

A)  Right-click a blank area 
B)  Go to the property sheet 
C)  Hide the detail section 
D)  Grey out a section 
A)  Right-click a blank area 
B)  Go to the property sheet 
C)  Hide the detail section 
D)  Grey out a section

Question 11

What must you do once a text box has been converted to a combo box?

Accepted Answer

A)  Set a source for the combo box 
B)  Set a default value 
C)  Create a validation rule 
D)  Create an input mask 
A)  Set a source for the combo box 
B)  Set a default value 
C)  Create a validation rule 
D)  Create an input mask

Question 12

Which of the following is NOT a correct way to Add a calculated control to a form or report?

Accepted Answer

A)  Use the Expression Builder 
B)  Create a formula in an unbound control 
C)  Create a formula beginning with the equal sign (=) in a text box 
D)  Create a formula in a bound control 
A)  Use the Expression Builder 
B)  Create a formula in an unbound control 
C)  Create a formula beginning with the equal sign (=) in a text box 
D)  Create a formula in a bound control

Question 13

In a form or report, a(n) ________ is a control that is not tied to a specific field.

Accepted Answer

The answer of In a form or report, a(n) ________...

Question 14

How would you add grouping to a report?

Accepted Answer

A)  Group & Sort button 
B)  Form footer 
C)  Page footer 
D)  Form header 
A)  Group & Sort button 
B)  Form footer 
C)  Page footer 
D)  Form header

On a form, what type of control provides a drop-down menu displaying a list of options from which the user can choose a single value?

Which of the following fields is an example of a field that would not require a tab stop?

You can adjust the tab order to control the advancement from one field or control to the next.

Which of the following displays when you insert a text box?

What is the purpose of a read-only form?

A page footer appears at the bottom of the last page of a form or report.

By using a ________, you can create a form that displays records from two related tables.

A calculated control contains an expression that generates a calculated result.

Where is the Page Header located?

How do you switch on or off sections of a report or form?

What must you do once a text box has been converted to a combo box?

Which of the following is NOT a correct way to Add a calculated control to a form or report?

In a form or report, a(n) ________ is a control that is not tied to a specific field.

How would you add grouping to a report?

Introduction to Access: Finding Your Way Through an Access Database

Tables and Queries in Relational Databases: Designing Databases and Extracting Data

Customize, Analyze, and Summarize Query Data: Creating and Using Queries to Make Decisions

Creating and Using Professional Forms and Reports: Moving Beyond Tables and Queries

Data Validation and Data Analysis: Reducing Errors and Extracting Better Information

Action and Specialized Queries: Moving Beyond the Select Query

Get Connected: Exchanging Data Between Access and Other Applications

Fine-Tuning the Database: Analyzing and Improving Database Performance

Using Macros and Sqlin Access: Advanced Techniques

Office Fundamentals and File Management

Filters

Exam 7: Advanced Forms and Reports: Moving Beyond the Basics

On a form, what type of control provides a drop-down menu displaying a list of options from which the user can choose a single value?

Which of the following fields is an example of a field that would not require a tab stop?

You can adjust the tab order to control the advancement from one field or control to the next.

Which of the following displays when you insert a text box?

What is the purpose of a read-only form?

A page footer appears at the bottom of the last page of a form or report.

By using a ________, you can create a form that displays records from two related tables.

A calculated control contains an expression that generates a calculated result.

Where is the Page Header located?

How do you switch on or off sections of a report or form?

What must you do once a text box has been converted to a combo box?

Which of the following is NOT a correct way to Add a calculated control to a form or report?

In a form or report, a(n) ________ is a control that is not tied to a specific field.

How would you add grouping to a report?

Introduction to Access: Finding Your Way Through an Access Database

Tables and Queries in Relational Databases: Designing Databases and Extracting Data

Customize, Analyze, and Summarize Query Data: Creating and Using Queries to Make Decisions

Creating and Using Professional Forms and Reports: Moving Beyond Tables and Queries

Data Validation and Data Analysis: Reducing Errors and Extracting Better Information

Action and Specialized Queries: Moving Beyond the Select Query

Get Connected: Exchanging Data Between Access and Other Applications

Fine-Tuning the Database: Analyzing and Improving Database Performance

Using Macros and Sqlin Access: Advanced Techniques

Office Fundamentals and File Management

Filters