Question 1

What is the difference between a form header and a page header?

Accepted Answer

The form footer appears one ti

Question 2

How do you hide details in a report?

Accepted Answer

A)  Click Hide details in the Grouping & Totals group on the Design tab 
B)  Close the detail section in Design view 
C)  Click Hide details in the Header/Footer Options 
D)  Click Hide details in Page Options 
A)  Click Hide details in the Grouping & Totals group on the Design tab 
B)  Close the detail section in Design view 
C)  Click Hide details in the Header/Footer Options 
D)  Click Hide details in Page Options

Question 3

Calculated controls begin with a(n):

Accepted Answer

A)  equal sign (=). 
B)  plus sign (+). 
C)  pound sign (#). 
D)  bracket ([ ]). 
A)  equal sign (=). 
B)  plus sign (+). 
C)  pound sign (#). 
D)  bracket ([ ]).

Question 4

The three views in Access are Form or Report view, Layout view, and Design view.

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A)  read-only form 
B)  data entry form 
C)  sub form 
D)  split form 
A)  read-only form 
B)  data entry form 
C)  sub form 
D)  split form

Question 6

Which of the following is an alternative to a combo box?

Accepted Answer

A)  Add a data validation rule 
B)  Key in the field 
C)  Set a tab order 
D)  Make it a required field 
A)  Add a data validation rule 
B)  Key in the field 
C)  Set a tab order 
D)  Make it a required field

Question 7

When would a calculated field need to be added to a form or report?

Accepted Answer

A)  When a formula is needed in the form or report 
B)  When you want to add some explanatory text to the form or report 
C)  When using an unbound control in the form or report 
D)  When using a bound control in the form or report 
A)  When a formula is needed in the form or report 
B)  When you want to add some explanatory text to the form or report 
C)  When using an unbound control in the form or report 
D)  When using a bound control in the form or report

Question 8

Forms and reports based on a query can display calculated fields like any other field.

Accepted Answer

A) True 
 B)False

Question 9

A locked form displays data but does not allow any changes to the data.

Accepted Answer

A) True 
 B)False

Question 10

Tab order cannot be changed in a form once it has been created.

Accepted Answer

A) True 
 B)False

Question 11

To move a text box label, what action must you take?

Accepted Answer

A)  Click the Tabular Layout in the Table group of the Arrange tab while both the label and text box controls are selected. 
B)  Click the Tabular Layout in the Arrange group when the label is selected. 
C)  Click the Tabular Layout in the Arrange group when the text box is selected. 
D)  Click the Tabular Layout in the Arrange group of the Table group while the label and text box are selected. 
A)  Click the Tabular Layout in the Table group of the Arrange tab while both the label and text box controls are selected. 
B)  Click the Tabular Layout in the Arrange group when the label is selected. 
C)  Click the Tabular Layout in the Arrange group when the text box is selected. 
D)  Click the Tabular Layout in the Arrange group of the Table group while the label and text box are selected.

Question 12

Which of the following generally refers to decorative elements such as the title of a report?

Accepted Answer

A)  Unbound control 
B)  Bound control 
C)  Calculated control 
D)  Text box 
A)  Unbound control 
B)  Bound control 
C)  Calculated control 
D)  Text box

Question 13

Page breaks can be added at specific locations in forms or reports.

Accepted Answer

A) True 
 B)False

Question 14

What is the difference between a bound control and an unbound control?

Accepted Answer

A bound control is connected t

Question 15

Both label controls and text box controls are known as bound controls.

Accepted Answer

A) True 
 B)False

Question 16

To remove a tab stop, click the Other tab in the Property sheet and change the Tab Stop setting to No.

Accepted Answer

A) True 
 B)False

Question 17

The three views in Access are Form or Report view, Layout view, and Design view.

Accepted Answer

A) True 
 B)False

Question 18

To change the order in which a user would enter data into a form, you would change the ________.

Accepted Answer

The answer of To change the order in which a...

Question 19

The ________ appears after adding a grouping to a form or report.

Accepted Answer

A)  Group Header 
B)  Group Footer 
C)  Page Header 
D)  Page Footer 
A)  Group Header 
B)  Group Footer 
C)  Page Header 
D)  Page Footer

Question 20

Sections can be used in reports but not in forms.

Accepted Answer

A) True 
 B)False

What is the difference between a form header and a page header?

How do you hide details in a report?

Calculated controls begin with a(n):

The three views in Access are Form or Report view, Layout view, and Design view.

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

Which of the following is an alternative to a combo box?

When would a calculated field need to be added to a form or report?

Forms and reports based on a query can display calculated fields like any other field.

A locked form displays data but does not allow any changes to the data.

Tab order cannot be changed in a form once it has been created.

To move a text box label, what action must you take?

Which of the following generally refers to decorative elements such as the title of a report?

Page breaks can be added at specific locations in forms or reports.

What is the difference between a bound control and an unbound control?

Both label controls and text box controls are known as bound controls.

To remove a tab stop, click the Other tab in the Property sheet and change the Tab Stop setting to No.

The three views in Access are Form or Report view, Layout view, and Design view.

To change the order in which a user would enter data into a form, you would change the ________.

The ________ appears after adding a grouping to a form or report.

Sections can be used in reports but not in forms.

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

What is the difference between a form header and a page header?

How do you hide details in a report?

Calculated controls begin with a(n):

The three views in Access are Form or Report view, Layout view, and Design view.

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

Which of the following is an alternative to a combo box?

When would a calculated field need to be added to a form or report?

Forms and reports based on a query can display calculated fields like any other field.

A locked form displays data but does not allow any changes to the data.

Tab order cannot be changed in a form once it has been created.

To move a text box label, what action must you take?

Which of the following generally refers to decorative elements such as the title of a report?

Page breaks can be added at specific locations in forms or reports.

What is the difference between a bound control and an unbound control?

Both label controls and text box controls are known as bound controls.

To remove a tab stop, click the Other tab in the Property sheet and change the Tab Stop setting to No.

The three views in Access are Form or Report view, Layout view, and Design view.

To change the order in which a user would enter data into a form, you would change the ________.

The ________ appears after adding a grouping to a form or report.

Sections can be used in reports but not in forms.

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