Question 1

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 2

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 3

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 4

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

Accepted Answer

A) True 
 B)False

Question 5

A form ____ is the general way that the data and controls are arranged on the form.

Accepted Answer

A)  view 
B)  group 
C)  control 
D)  layout 
A)  view 
B)  group 
C)  control 
D)  layout

Question 6

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

Accepted Answer

A)  Combo box 
B)  Datasheet 
C)  Subform 
D)  Query 
A)  Combo box 
B)  Datasheet 
C)  Subform 
D)  Query

Question 7

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 8

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 9

Explain what types of commands can be added using the Command Button Wizard?

Accepted Answer

The Command Button Wizard lists 28 of th

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

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 12

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 13

Anchoring means to position and tie a control to other controls so they can move or resize together.

Accepted Answer

A) True 
 B)False

Question 14

Aligning the edges of controls generally makes them easier to read and use.

Accepted Answer

A) True 
 B)False

Question 15

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 16

A(n) ____________________ control is a form within a form.

Accepted Answer

The answer of A(n) ____________________ control is a form within...

Question 17

Which of the following form sections often contains command buttons?

Accepted Answer

A)  Commands 
B)  Form Header 
C)  Page Footer 
D)  Report Footer 
A)  Commands 
B)  Form Header 
C)  Page Footer 
D)  Report Footer

Question 18

Fields with Lookup properties are automatically created as combo boxes on new forms.

Accepted Answer

A) True 
 B)False

Question 19

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 20

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

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

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

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

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

A form ____ is the general way that the data and controls are arranged on the form.

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

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

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

Explain what types of commands can be added using the Command Button Wizard?

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

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.

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

Anchoring means to position and tie a control to other controls so they can move or resize together.

Aligning the edges of controls generally makes them easier to read and use.

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

A(n) ____________________ control is a form within a form.

Which of the following form sections often contains command buttons?

Fields with Lookup properties are automatically created as combo boxes on new forms.

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

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

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

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

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

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

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

A form ____ is the general way that the data and controls are arranged on the form.

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

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

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

Explain what types of commands can be added using the Command Button Wizard?

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

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.

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

Anchoring means to position and tie a control to other controls so they can move or resize together.

Aligning the edges of controls generally makes them easier to read and use.

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

A(n) ____________________ control is a form within a form.

Which of the following form sections often contains command buttons?

Fields with Lookup properties are automatically created as combo boxes on new forms.

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

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

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