Question 1

The Enabled property specifies whether a control can be edited in Form View.

Accepted Answer

A) True 
 B)False  False

Question 2

Which control provides a "drop-down list" behavior?

Accepted Answer

A)  Text Box 
B)  Label 
C)  Combo Box 
D)  List Box 
A)  Text Box 
B)  Label 
C)  Combo Box 
D)  List Box C

Question 3

A(n) ____________________ is a database object designed to make data easy to find, enter, and edit.

Accepted Answer

form

Question 4

Design View of a form is devoted to productively entering and editing data.

Accepted Answer

A) True 
 B)False

Question 5

In Form Design View, you can press and hold ____ to select multiple controls together?

Accepted Answer

A)  Alt 
B)  Caps Lock 
C)  F2 
D)  Shift 
A)  Alt 
B)  Caps Lock 
C)  F2 
D)  Shift

Question 6

You can modify the Caption property to change the text that appears on the tab in Form View.

Accepted Answer

A) True 
 B)False

Question 7

It is useful to add a command button to a form that will print the current record.

Accepted Answer

A) True 
 B)False

Question 8

In the accompanying figure, the first label in the main form is ____________________.

Accepted Answer

The answer of   In the accompanying figure, the...

Question 9

Which two properties control how a form and subform are linked?

Accepted Answer

A)  Link Child Fields and Link Master Fields 
B)  Form and Subform 
C)  Link Form and Link Subform 
D)  Form Layout and Subform Layout 
A)  Link Child Fields and Link Master Fields 
B)  Form and Subform 
C)  Link Form and Link Subform 
D)  Form Layout and Subform Layout

Question 10

Match between columns
                        Premises: A bound control showing mutually exclusive field entries
Shows records related to a record in the main form
An element added to a form, for example, a label
One choice within an option group
A bound control that is a list box and a text box
An unbound control that executes an action when clicked
Used to control whether you can type an entry into a combo box

Accepted Answer

The Answer of Option button and Subform and Control and is...

Question 11

The combo box gets its values from the list entered in the ____ property.

Accepted Answer

A)  Recordset 
B)  Limit to List 
C)  Data List 
D)  Row Source 
A)  Recordset 
B)  Limit to List 
C)  Data List 
D)  Row Source

Question 12

The link between a main form and a subform is established through a common ____.

Accepted Answer

A)  record 
B)  set of records 
C)  field 
D)  control 
A)  record 
B)  set of records 
C)  field 
D)  control

Question 13

Explain the relationship between the option group and option button controls.

Accepted Answer

An option group is a bound control that

Question 14

Explain how you can use a combo box to help users find data in a form used to edit customer data.

Accepted Answer

You can add a combo box with a

Question 15

Briefly explain the two ways to use a combo box control on a form.

Accepted Answer

You can use a combo box for da

Question 16

The ____ property determines the layout of a form.

Accepted Answer

A)  Appearance 
B)  Format 
C)  Form View 
D)  Default View 
A)  Appearance 
B)  Format 
C)  Form View 
D)  Default View

Question 17

In the accompanying figure, item number 2 is a(n) number box control.

Accepted Answer

A) True 
 B)False

Question 18

A subform allows you to work with records related to the record in the main form.

Accepted Answer

A) True 
 B)False

Question 19

Explain the benefits of using a subform for the Sales data in the accompanying figure.

Accepted Answer

Benefits of using a subform ar

Question 20

The ____________________ Child Fields property is used to connect a form to a subform.

Accepted Answer

The answer of The ____________________ Child Fields property is used...

The Enabled property specifies whether a control can be edited in Form View.

Which control provides a "drop-down list" behavior?

A(n) ____________________ is a database object designed to make data easy to find, enter, and edit.

Design View of a form is devoted to productively entering and editing data.

In Form Design View, you can press and hold ____ to select multiple controls together?

You can modify the Caption property to change the text that appears on the tab in Form View.

It is useful to add a command button to a form that will print the current record.

In the accompanying figure, the first label in the main form is ____________________.

Which two properties control how a form and subform are linked?

The combo box gets its values from the list entered in the ____ property.

The link between a main form and a subform is established through a common ____.

Explain the relationship between the option group and option button controls.

Explain how you can use a combo box to help users find data in a form used to edit customer data.

Briefly explain the two ways to use a combo box control on a form.

The ____ property determines the layout of a form.

In the accompanying figure, item number 2 is a(n) number box control.

A subform allows you to work with records related to the record in the main form.

Explain the benefits of using a subform for the Sales data in the accompanying figure.

The ____________________ Child Fields property is used to connect a form to a subform.

Getting Started With Microsoft Office 2013

Getting Started With Access 2013

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Enhancing Forms

Analyzing Data With Reports

Filters

Exam 7: Improving Queries

The Enabled property specifies whether a control can be edited in Form View.

Which control provides a "drop-down list" behavior?

A(n) ____________________ is a database object designed to make data easy to find, enter, and edit.

Design View of a form is devoted to productively entering and editing data.

In Form Design View, you can press and hold ____ to select multiple controls together?

You can modify the Caption property to change the text that appears on the tab in Form View.

It is useful to add a command button to a form that will print the current record.

In the accompanying figure, the first label in the main form is ____________________.

Which two properties control how a form and subform are linked?

The combo box gets its values from the list entered in the ____ property.

The link between a main form and a subform is established through a common ____.

Explain the relationship between the option group and option button controls.

Explain how you can use a combo box to help users find data in a form used to edit customer data.

Briefly explain the two ways to use a combo box control on a form.

The ____ property determines the layout of a form.

In the accompanying figure, item number 2 is a(n) number box control.

A subform allows you to work with records related to the record in the main form.

Explain the benefits of using a subform for the Sales data in the accompanying figure.

The ____________________ Child Fields property is used to connect a form to a subform.

Getting Started With Microsoft Office 2013

Getting Started With Access 2013

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Enhancing Forms

Analyzing Data With Reports

Filters