Deck 7: Enhancing Forms Question

Question 1

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

Answer 1

A

Question 2

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

Answer 2

True

Question 3

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

Answer 3

False

Question 4

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

Question 5

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

Question 6

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

A)Command button
B)List Box
C)Combo Box
D)Text Box

Question 7

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

Question 8

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

Question 9

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

Question 10

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

Question 11

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

Question 12

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

Question 13

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

Question 14

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

A)Text box
B)Title box
C)Label
D)Option box

Question 15

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

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

Question 16

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

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

Question 17

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

Question 18

The figure above, item 3 refers to a(n)___:

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

Question 19

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

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

Question 20

The title bar of the property sheet indicates the control you are working with.

Question 21

The ____ property determines the layout of the form.

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

Question 22

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 23

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 24

The Align button, which aligns the edges of controls, is found by clicking which tab on the Ribbon?

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

Question 25

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

A)6
B)8
C)35
D)Not enough information

Question 26

The Limit to List property would be associated with which type of control?

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

Question 27

This form section 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 28

This control provides a "drop-down list" behavior.

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

Question 29

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 30

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 31

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

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

Question 32

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 33

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 34

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

A)Record
B)Set of records
C)Field
D)Control

Question 35

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

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

Question 36

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

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

Question 37

This form section 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 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

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

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

Question 40

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

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

Question 41

Item number 2 is a number box control.

Question 42

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 43

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

Question 44

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

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

Question 45

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

Question 46

The ____________________ form section appears once for every individual record.

Question 47

Which of the following form sections often contains command buttons?

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

Question 48

Item number 1 is a text box control.

Question 49

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

Question 50

____________________ is the default layout for a main form.

Question 51

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

Question 52

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

Question 53

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

Question 54

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

Question 55

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

Question 56

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

Question 57

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

Question 58

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

Question 59

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

Question 60

A common control to place within an option group is the ____.

A)Option button
B)Command button
C)Text box
D)Combo box

Question 62

Explain why a combo box is the best choice for the State data in the figure above.

Question 63

The Detail section appears once for every record on a form.

Question 64

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

Question 65

Most combo boxes are used to enter data.

Question 66

The PivotTable layout organizes fields in a PivotChart arrangement.

Question 67

Explain the benefits of using a combo box control for the Gender data in the figure above.

Question 68

Explain why a text box as opposed to a combo box is the best choice for the Phone and Email data shown in the figure above.

Question 69

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