Question 1

In the accompanying figure, item 1 points to the navigation bar for the main form.

Accepted Answer

A) True 
 B)False

Question 2

By default, the Default View property of a subform is Datasheet.

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

An option group is a bound control that

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

You can open the Field List with the Add Existing Fields button. _________________________

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

The title bar of the Property Sheet indicates the control you are working with.

Accepted Answer

A) True 
 B)False

Question 8

Which of the following form sections appears at the top of a printed form and often contains information such as page numbers or dates?

Accepted Answer

A)  Detail 
B)  Page Header 
C)  Form Header 
D)  Section Header 
A)  Detail 
B)  Page Header 
C)  Form Header 
D)  Section Header

Question 9

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

Accepted Answer

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

Question 10

Explain why a text box rather than a combo box is the best choice for the FName and LName data fields shown in the accompanying figure.

Accepted Answer

There are endless possibilities for the

Question 11

The ____ determines the underlying table or query for a form.

Accepted Answer

A)  record source 
B)  attachment property 
C)  combo box 
D)  command button 
A)  record source 
B)  attachment property 
C)  combo box 
D)  command button

Question 12

Discuss the two different control properties you can use to protect data on a form.

Accepted Answer

The Enabled property specifies

Question 13

Which of the following form sections appears only when the form is printed?

Accepted Answer

A)  Detail 
B)  Form Header 
C)  Print Header 
D)  Page Header 
A)  Detail 
B)  Form Header 
C)  Print Header 
D)  Page Header

Question 14

In the accompanying figure, item 1 refers to a(n) ____.

Accepted Answer

A)  text box 
B)  title box 
C)  label 
D)  option box 
A)  text box 
B)  title box 
C)  label 
D)  option box

Question 15

Generally there is a one-to-many relationship between the record in the main form and the records in a subform.

Accepted Answer

A) True 
 B)False

Question 16

A(n) ____ is a common control to place within an option group.

Accepted Answer

A)  option button 
B)  command button 
C)  text box 
D)  combo box 
A)  option button 
B)  command button 
C)  text box 
D)  combo box

Question 17

You modify the Default View property to change the form layout . _________________________

Accepted Answer

A) True 
 B)False

Question 18

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 19

In the accompanying figure, if you drag the line identified by 2 you will ____.

Accepted Answer

A)  delete the field 
B)  edit field values 
C)  resize the column 
D)  define the layout 
A)  delete the field 
B)  edit field values 
C)  resize the column 
D)  define the layout

Question 20

The Detail section of a form appears once for every record. _________________________

Accepted Answer

A) True 
 B)False

In the accompanying figure, item 1 points to the navigation bar for the main form.

By default, the Default View property of a subform is Datasheet.

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

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

You can open the Field List with the Add Existing Fields button. _________________________

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

The title bar of the Property Sheet indicates the control you are working with.

Which of the following form sections appears at the top of a printed form and often contains information such as page numbers or dates?

Explain why a text box rather than a combo box is the best choice for the FName and LName data fields shown in the accompanying figure.

The ____ determines the underlying table or query for a form.

Discuss the two different control properties you can use to protect data on a form.

Which of the following form sections appears only when the form is printed?

In the accompanying figure, item 1 refers to a(n) ____.

Generally there is a one-to-many relationship between the record in the main form and the records in a subform.

A(n) ____ is a common control to place within an option group.

You modify the Default View property to change the form layout . _________________________

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

In the accompanying figure, if you drag the line identified by 2 you will ____.

The Detail section of a form appears once for every record. _________________________

Getting Started With Access 2013

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Improving Queries

Analyzing Data With Reports

Importing and Exporting Data

Analyzing Database Design Using Northwind

Creating Advanced Queries

Creating Advanced Reports

Creating Macros

Creating Macros

Administering the Database

Access and the Web

Getting Started With Microsoft Office 2013

Filters

Exam 7: Enhancing Forms

In the accompanying figure, item 1 points to the navigation bar for the main form.

By default, the Default View property of a subform is Datasheet.

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

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

You can open the Field List with the Add Existing Fields button. _________________________

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

The title bar of the Property Sheet indicates the control you are working with.

Which of the following form sections appears at the top of a printed form and often contains information such as page numbers or dates?

Explain why a text box rather than a combo box is the best choice for the FName and LName data fields shown in the accompanying figure.

The ____ determines the underlying table or query for a form.

Discuss the two different control properties you can use to protect data on a form.

Which of the following form sections appears only when the form is printed?

In the accompanying figure, item 1 refers to a(n) ____.

Generally there is a one-to-many relationship between the record in the main form and the records in a subform.

A(n) ____ is a common control to place within an option group.

You modify the Default View property to change the form layout . _________________________

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

In the accompanying figure, if you drag the line identified by 2 you will ____.

The Detail section of a form appears once for every record. _________________________

Getting Started With Access 2013

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Improving Queries

Analyzing Data With Reports

Importing and Exporting Data

Analyzing Database Design Using Northwind

Creating Advanced Queries

Creating Advanced Reports

Creating Macros

Creating Macros

Administering the Database

Access and the Web

Getting Started With Microsoft Office 2013

Filters