Question 1

In Form Design View, you can press and hold ____ to add more controls to a selection.

Accepted Answer

A)  Alt or Caps Lock 
B)  F6 or F7 
C)  F1 or F2 
D)  Ctrl or Shift 
A)  Alt or Caps Lock 
B)  F6 or F7 
C)  F1 or F2 
D)  Ctrl or Shift D

Question 2

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

Accepted Answer

The Command Button Wizard lists 28 of the most popular actions for a command button in the categories of Record Navigation, Record Operations, Form Operations, Report Operations, Application, and Miscellaneous.

Question 3

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

Accepted Answer

subform

Question 4

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

Accepted Answer

There are endless possibilities for the

Question 5

On a form, _____ are created for each bound control.

Accepted Answer

A)  combo boxes 
B)  option boxes 
C)  captions 
D)  labels 
A)  combo boxes 
B)  option boxes 
C)  captions 
D)  labels

Question 6

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 7

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

Accepted Answer

A) True 
 B)False

Question 8

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 9

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 10

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 11

The Align button, which aligns the edges of controls, is found on the ____ tab on the Ribbon.

Accepted Answer

A)  Home 
B)  Arrange 
C)  Design 
D)  Layout 
A)  Home 
B)  Arrange 
C)  Design 
D)  Layout

Question 12

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 13

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 14

The ____ shows the fields you can add to a form.

Accepted Answer

A)  Property Sheet 
B)  Field List 
C)  subform 
D)  option group 
A)  Property Sheet 
B)  Field List 
C)  subform 
D)  option group

Question 15

Explain why a combo box is the best choice for a TripNo data field that is updated when another customer signs up for a trip.

Accepted Answer

A TripNo field would have a li

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

A(n) ____________________ group is a bound control that is often used when a limited number of mutually exclusive values are available for a field.

Accepted Answer

The answer of A(n) ____________________ group is a bound control...

Question 19

Which of the following form sections appears at the top of the form and often contains command buttons or a label with the title of the form?

Accepted Answer

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

Question 20

Give two reasons why a combo box control is more popular than a list box control for data entry.

Accepted Answer

A combo box allows the user to enter a n

In Form Design View, you can press and hold ____ to add more controls to a selection.

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

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

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

On a form, _____ are created for each bound control.

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

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

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

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

Which of the following form sections often contains command buttons?

The Align button, which aligns the edges of controls, is found on the ____ tab on the Ribbon.

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

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

The ____ shows the fields you can add to a form.

Explain why a combo box is the best choice for a TripNo data field that is updated when another customer signs up for a trip.

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

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

A(n) ____________________ group is a bound control that is often used when a limited number of mutually exclusive values are available for a field.

Which of the following form sections appears at the top of the form and often contains command buttons or a label with the title of the form?

Give two reasons why a combo box control is more popular than a list box control for data entry.

Getting Started With Access

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Improving Queries

Analyizng Data With Reports

Importing and Exporting Data

Creating Advanced Queries

Creating Advanced Reports

Creating Macros

Creating Modules and Vba

Administering the Database

Using Acess and the Web

Completing a Database Application

Filters

Exam 7: Enhancing Forms

In Form Design View, you can press and hold ____ to add more controls to a selection.

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

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

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

On a form, _____ are created for each bound control.

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

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

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

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

Which of the following form sections often contains command buttons?

The Align button, which aligns the edges of controls, is found on the ____ tab on the Ribbon.

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

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

The ____ shows the fields you can add to a form.

Explain why a combo box is the best choice for a TripNo data field that is updated when another customer signs up for a trip.

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

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

A(n) ____________________ group is a bound control that is often used when a limited number of mutually exclusive values are available for a field.

Which of the following form sections appears at the top of the form and often contains command buttons or a label with the title of the form?

Give two reasons why a combo box control is more popular than a list box control for data entry.

Getting Started With Access

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Improving Queries

Analyizng Data With Reports

Importing and Exporting Data

Creating Advanced Queries

Creating Advanced Reports

Creating Macros

Creating Modules and Vba

Administering the Database

Using Acess and the Web

Completing a Database Application

Filters