Question 1

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 2

________ controls are connected to a field on a query or table.

Accepted Answer

The answer of ________ controls are connected to a field...

Question 3

Which of the following is not a reason to restrict who can edit data in a form?

Accepted Answer

A) Data can become unreliable. 
B) Data can become hard to maintain. 
C) The wrong people might be able to delete the records. 
D) The file will get too large. 
A) Data can become unreliable. 
B) Data can become hard to maintain. 
C) The wrong people might be able to delete the records. 
D) The file will get too large.

Question 4

Match between columns
                        Premises: Control
Subform
Section bar
Read-only form
Tab order

Accepted Answer

The Answer of Usually displayed in tabular fashion and Sequential is...

Question 5

Match between columns
                        Premises: Group header
Page header
Group footer
Page footer
Section

Accepted Answer

The Answer of Displays at the bottom of each page is...

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

Which of the following is a recommended way of informing users that a form is read-only?

Accepted Answer

A) Include a note in the form title. 
B) Have a message box appear any time the form is opened. 
C) There is no need to inform the user. 
D) There is never a need to make a form read-only. 
A) Include a note in the form title. 
B) Have a message box appear any time the form is opened. 
C) There is no need to inform the user. 
D) There is never a need to make a form read-only.

Question 8

Group headers and footers cannot be added to a form.

Accepted Answer

A) True 
 B)False

Question 9

Which of the following are not customizations you can make to a form?

Accepted Answer

A) Change the tab order 
B) Convert a form to a report 
C) Convert a text box to a menu 
D) Make a form read-only 
A) Change the tab order 
B) Convert a form to a report 
C) Convert a text box to a menu 
D) Make a form read-only

Question 10

Match between columns
                        Premises: Label
Image
Subform/Subreport
Text box
Calculated

Accepted Answer

The Answer of Aggregated function and Form or report inside is...

Question 11

A(n)________ control displays the results of an expression in a form or report.

Accepted Answer

The answer of A(n)________ control displays the results of an...

Question 12

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 13

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

Accepted Answer

A) True 
 B)False

Question 14

Subforms are generally laid out in a(n)________ fashion.

Accepted Answer

The answer of Subforms are generally laid out in a(n)________...

Question 15

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 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

The tab order can be set manually if necessary.

Accepted Answer

A) True 
 B)False

Question 18

Combo Boxes must be created at the same time the source table is created.

Accepted Answer

A) True 
 B)False

Question 19

A form that enables users to view but not change data is what type of form?

Accepted Answer

A) Restrict-only 
B) DataView-only 
C) Read-only 
D) DataView 
A) Restrict-only 
B) DataView-only 
C) Read-only 
D) DataView

Question 20

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

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

________ controls are connected to a field on a query or table.

Which of the following is not a reason to restrict who can edit data in a form?

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

Which of the following is a recommended way of informing users that a form is read-only?

Group headers and footers cannot be added to a form.

Which of the following are not customizations you can make to a form?

A(n)________ control displays the results of an expression in a form or report.

How does a Combo Box control appear to a user?

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

Subforms are generally laid out in a(n)________ fashion.

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

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

The tab order can be set manually if necessary.

Combo Boxes must be created at the same time the source table is created.

A form that enables users to view but not change data is what type of form?

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

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

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

________ controls are connected to a field on a query or table.

Which of the following is not a reason to restrict who can edit data in a form?

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

Which of the following is a recommended way of informing users that a form is read-only?

Group headers and footers cannot be added to a form.

Which of the following are not customizations you can make to a form?

A(n)________ control displays the results of an expression in a form or report.

How does a Combo Box control appear to a user?

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

Subforms are generally laid out in a(n)________ fashion.

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

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

The tab order can be set manually if necessary.

Combo Boxes must be created at the same time the source table is created.

A form that enables users to view but not change data is what type of form?

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

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