Question 1

In the accompanying figure, how many records are in the subform?

Accepted Answer

A)  2 
B)  7 
C)  10 
D)  49 
A)  2 
B)  7 
C)  10 
D)  49

Question 2

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

Accepted Answer

Benefits of using a subform ar

Question 3

A form that contains a subform is called the master form.

Accepted Answer

A) True 
 B)False

Question 4

Which form layout shows each field name as a column heading and each record as a row?

Accepted Answer

A)  Columnar 
B)  Tabular 
C)  Chart 
D)  PivotTable 
A)  Columnar 
B)  Tabular 
C)  Chart 
D)  PivotTable

Question 5

In the ____________________ layout, each field appears as an individual column, and each record is presented as a row.

Accepted Answer

The answer of In the ____________________ layout, each field appears...

Question 6

Explain why a combo box is the best choice for the FirstContact data field shown in the accompanying figure.

Accepted Answer

A FirstContact field would hav

Question 7

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 8

In the accompanying figure, how many fields are in the subform?

Accepted Answer

A)  5 
B)  6 
C)  7 
D)  8 
A)  5 
B)  6 
C)  7 
D)  8

Question 9

In the accompanying figure, the subform is shown in which layout?

Accepted Answer

A)  Columnar 
B)  Tabular 
C)  Datasheet 
D)  Simple 
A)  Columnar 
B)  Tabular 
C)  Datasheet 
D)  Simple

Question 10

Most combo boxes are used to enter data. _________________________

Accepted Answer

A) True 
 B)False

Question 11

In the accompanying figure, item 6 refers to what type of control?

Accepted Answer

A)  Option Group 
B)  Option Button 
C)  Command Toggle 
D)  Command Button 
A)  Option Group 
B)  Option Button 
C)  Command Toggle 
D)  Command Button

Question 12

In the accompanying figure, the third field in the subform is ____________________.

Accepted Answer

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

Question 13

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 14

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

Accepted Answer

The answer of A(n) ____________________ is a database object designed...

Question 15

To modify the number of items displayed in a combo box list, you use the ____ property.

Accepted Answer

A)  Control Source 
B)  List Rows 
C)  Limit to List 
D)  Drop-Down 
A)  Control Source 
B)  List Rows 
C)  Limit to List 
D)  Drop-Down

Question 16

In the accompanying figure, how many records are in the main form?

Accepted Answer

A)  2 
B)  7 
C)  10 
D)  49 
A)  2 
B)  7 
C)  10 
D)  49

Question 17

The Limit to List property is associated with the ____ control.

Accepted Answer

A)  combo box 
B)  list box 
C)  text box 
D)  menu list 
A)  combo box 
B)  list box 
C)  text box 
D)  menu list

Question 18

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 19

A(n) ____________________ button is a control used to initiate common actions, such as printing a record or opening another form.

Accepted Answer

The answer of A(n) ____________________ button is a control used...

Question 20

One or more option buttons can be chosen at the same time within an option group.

Accepted Answer

A) True 
 B)False

In the accompanying figure, how many records are in the subform?

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

A form that contains a subform is called the master form.

Which form layout shows each field name as a column heading and each record as a row?

In the ____________________ layout, each field appears as an individual column, and each record is presented as a row.

Explain why a combo box is the best choice for the FirstContact data field shown in the accompanying figure.

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

In the accompanying figure, how many fields are in the subform?

In the accompanying figure, the subform is shown in which layout?

Most combo boxes are used to enter data. _________________________

In the accompanying figure, item 6 refers to what type of control?

In the accompanying figure, the third field in the subform is ____________________.

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

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

To modify the number of items displayed in a combo box list, you use the ____ property.

In the accompanying figure, how many records are in the main form?

The Limit to List property is associated with the ____ control.

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

A(n) ____________________ button is a control used to initiate common actions, such as printing a record or opening another form.

One or more option buttons can be chosen at the same time within an option group.

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, how many records are in the subform?

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

A form that contains a subform is called the master form.

Which form layout shows each field name as a column heading and each record as a row?

In the ____________________ layout, each field appears as an individual column, and each record is presented as a row.

Explain why a combo box is the best choice for the FirstContact data field shown in the accompanying figure.

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

In the accompanying figure, how many fields are in the subform?

In the accompanying figure, the subform is shown in which layout?

Most combo boxes are used to enter data. _________________________

In the accompanying figure, item 6 refers to what type of control?

In the accompanying figure, the third field in the subform is ____________________.

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

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

To modify the number of items displayed in a combo box list, you use the ____ property.

In the accompanying figure, how many records are in the main form?

The Limit to List property is associated with the ____ control.

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

A(n) ____________________ button is a control used to initiate common actions, such as printing a record or opening another form.

One or more option buttons can be chosen at the same time within an option group.

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