Deck 8: Enhancing Forms

Question 1

By default, subforms display their controls the same way in both Design View and Form View.

Answer 1

False

Question 2

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

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

Answer 2

C

Question 3

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

Answer 3

True

Question 4

A combo box is a combination of the text box and command button controls.

Question 5

The accompanying figure, item 3 refers to a(n) ____.

A) option button
B) option box
C) option group
D) option command button

Question 6

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

Question 7

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

Question 8

In the accompanying figure, item 2 refers to a ____.

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

Question 9

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

Question 10

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

Question 11

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

Question 12

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

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

Question 13

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

Question 14

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

Question 15

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

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

Question 16

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

Question 17

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

Question 18

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

Question 19

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

A) Subform
B) Option Group
C) Combo box
D) Command button

Question 20

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

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

Question 21

The ____ property determines the layout of a form.

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

Question 22

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

A) HOME
B) ARRANGE
C) DESIGN
D) LAYOUT

Question 23

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

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 24

Which control allows you to choose from a list as well as make an entry from the keyboard?

A) Label
B) List box
C) Combo box
D) Command box

Question 25

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

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

Question 26

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

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

Question 27

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

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

Question 28

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

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

Question 29

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

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

Question 30

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

A) 8
B) 9
C) 10
D) 12

Question 31

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

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

Question 32

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

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

Question 33

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

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

Question 34

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

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

Question 35

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

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

Question 36

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

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

Question 37

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

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

Question 38

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

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

Question 39

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

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

Question 40

Which form layout shows each field on a separate line with a label to its left?

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

Question 41

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

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

Question 42

Both of these controls provide a list of values from which the user can choose an entry:

A) Text Box and List Box.
B) Text Box and Combo Box.
C) Drop-Down List and Combo Box.
D) List Box and Combo Box.

Question 43

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

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

Question 44

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

Question 45

____________________ layout is the default view for a main form.

Question 46

Which of the following properties corresponds with the value of each option button?

A) Option Value
B) Option Data
C) Control Data
D) Control Number

Question 47

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

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

Question 48

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

Question 49

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

Question 50

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

Question 51

The ____________________ form section appears once for every record.

Question 52

Which of the following form sections often contains command buttons?

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

Question 53

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

Question 54

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?

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

Question 55

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

Question 56

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

Question 57

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

Question 58

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

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

Question 59

The ____ creates a 3-D aspect to a form.

A) Split Form
B) Tab Control
C) Property Sheet
D) Report Footer

Question 60

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

Question 61

Match the term with the correct description.
a.Control
e.Subform
b.Option group
f.Option button
c.Combo box
g.Limit to List
d.Command button
Used to control whether you can type an entry into a combo box

Question 62

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

Question 63

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

Question 64

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

Question 65

To reorder the values in a combo box, modify the Sort List property. _________________________

Question 66

Match the term with the correct description.
a.Control
e.Subform
b.Option group
f.Option button
c.Combo box
g.Limit to List
d.Command button
An element added to a form, for example, a label

Question 67

Control margin is the space between the outside borders of adjacent controls. _________________________

Question 68

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

Question 69

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

Question 70

To modify the number of items displayed in a combo box, use the List Rows property. _________________________

Question 71

Most combo boxes are used to enter data. _________________________

Question 72

In the accompanying figure, item number 1 is a(n) text box control. _________________________

Question 73

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

Question 74

Match the term with the correct description.
a.Control
e.Subform
b.Option group
f.Option button
c.Combo box
g.Limit to List
d.Command button
Shows records related to a record in the main form

Question 75

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

Question 76

Match the term with the correct description.
a.Control
e.Subform
b.Option group
f.Option button
c.Combo box
g.Limit to List
d.Command button
An unbound control that executes an action when clicked

Question 77

Match the term with the correct description.
a.Control
e.Subform
b.Option group
f.Option button
c.Combo box
g.Limit to List
d.Command button
A bound control that is a list box and a text box

Question 78

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

Question 79

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

Question 80

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