Deck 4: Using Forms

Question 1

In the accompanying figure, the ____ tool will create a form with one click, based on the selected table or query.

A) first
B) second
C) third
D) fifth

Answer 1

A

Question 2

Which form creation tool can you use to create a form from scratch in Form Design View?

A) Form
B) Blank Form
C) Form Design
D) Form Wizard

Answer 2

C

Question 3

A form allows you to arrange the fields of a record in any layout so a database user can quickly and easily find, enter, edit, and analyze data.

Answer 3

True

Question 4

Each item on a form is called a control.

Question 5

Which of the following is NOT a form view?

A) Data
B) Form
C) Layout
D) Design

Question 6

If you want to apply the same formatting enhancement to multiple controls, select them at the same time to make the same change to both.

Question 7

You can add fields to a form in either Layout View or Design View.

Question 8

You can press an arrow key to move a selected control.

Question 9

A tab control is an unbound control.

Question 10

Which form creation tool can you use to create a form by answering a series of questions provided by dialog boxes?

A) Form Wizard
B) More Forms
C) Split Form
D) Navigation

Question 11

A background image is an image that fills the entire form or report, appearing "behind" the other controls.

Question 12

Which form creation tool can you use to build a form based on Multiple Items, Datasheet, or Split Form, for example?

A) Form Design
B) Blank Form
C) More Forms
D) Form Wizard

Question 13

Forms can be used to enter and edit data.

Question 14

Deleting a field from a form does not delete it from the underlying table or have any effect on the data contained in the field.

Question 15

In the accompanying figure, the first tool in the list creates a form from scratch in Form Design View.

Question 16

The Form Wizard prompts you for information it needs to create a form, such as the ____ for the form.

A) fields
B) title
C) layout
D) All of the above.

Question 17

Bound controls exist only to describe or enhance the appearance of the form.

Question 18

It would make sense to set the Tab Stop property of a text box that will not be used for data entry to No.

Question 19

On a form, text box controls display data from an underlying record source.

Question 20

The Spacing feature represents the space between controls.

Question 21

When an image or control is selected in Design View, you can use ____, which are small squares at the corners of the selection box, to resize the image.

A) label indices
B) sizing handles
C) combo boxes
D) command squares

Question 22

Which of the following would most likely be used to display a Yes/No field on a form?

A) Check box
B) Command button
C) Combo box
D) Label

Question 23

Which control displays a list of possible data entries from which the user can choose?

A) Label
B) Text box
C) List box
D) Tab control

Question 24

____ refers to the space between the outer edge of the control and the data displayed inside the control.

A) Spacing
B) Reference
C) Padding
D) Margin

Question 25

____ records are those on the many side of a relationship that do not have a match on the one side.

A) indexed
B) split
C) unlicensed
D) orphan

Question 26

Expressions must start with what character?

A) [ left square bracket
B) = equal sign
C) ( left parenthesis
D) : colon

Question 27

Which control is used to provide consistent descriptive text as you navigate from record to record?

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

Question 28

In the accompanying figure, the ____ tool will create a form from scratch in Form Layout View.

A) first
B) second
C) third
D) fourth

Question 29

In the accompanying figure, the ____ tool is used to navigate or move between different areas of the database.

A) first
B) second
C) third
D) fifth

Question 30

Which control, when it appears pressed, displays "yes" information?

A) Bound image control
B) Combo box
C) Tab control
D) Toggle button

Question 31

When referencing field names within an expression, surround the field name with ____.

A) [square brackets]
B) {curly brackets}
C) (parentheses)
D) "quotation marks"

Question 32

Which of the following is NOT a bound control?

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

Question 33

____ View lets you make some design changes to a form while you are browsing the data.

A) Layout
B) Design
C) Browse
D) Data

Question 34

Referential integrity prevents the creation of ____ records.

A) indexed
B) split
C) unlicensed
D) orphan

Question 35

Which control provides an easy way to initiate a command or run a macro?

A) Check box
B) Toggle button
C) Command button
D) Image control

Question 36

In the accompanying figure, the ____ tool will allow you to create a form by answering a series of questions provided by the Form Wizard dialog boxes.

A) second
B) third
C) fourth
D) fifth

Question 37

The Align button in the Sizing & Ordering group is available on the ____ tab.

A) ARRANGE
B) OPTIONS
C) HOME
D) FORMAT

Question 38

Which control is used to create a three-dimensional aspect to a form?

A) Command button
B) Toggle button
C) Rectangle control
D) Tab control

Question 39

You can press ____ to move the focus through the controls of the form.

A) [Page Down]
B) [Tab]
C) [F5]
D) [F12]

Question 40

Which control is both a list box and a text box control?

A) Bound image control
B) Unbound image control
C) Combo box
D) Option group

Question 41

Discuss the difference between tab order and tab stop.

Question 42

The ____________________ Sheet of a control is a comprehensive listing of all characteristics that you can modify for that control.

Question 43

On a form, ____________________ View is used to modify controls and does not display data.

Question 44

The lower pane of a split form displays a(n) datasheet view. _________________________

Question 45

Which of the following would NOT be considered a graphic image?

A) Picture
B) Logo
C) Text
D) Clip art

Question 46

Differentiate between bound and unbound controls.

Question 47

Click in the text box of the field you want to sort after clicking a sort button. _________________________

Question 48

When you modify controls, you change their ____________________, or characteristics.

Question 49

On a form, ____________________ View is used to enter, edit, and delete data.

Question 50

In a(n) ____________________ form, the upper pane shows the fields of one record while the lower pane maintains a datasheet view of the first few records.

Question 51

Controls placed in this form section print once for every record.

A) Form Records
B) Form Header
C) Form Footer
D) Detail

Question 52

Controls placed in the ____ form section print only once at the top of the printout.

A) Form Header
B) Detail
C) Form First
D) Form Top

Question 53

The Size/Space button is in the Alignment group on the ARRANGE tab. _________________________

Question 54

____________________ box controls are used to display as well as enter, edit, find, sort, and filter data on a form.

Question 55

The ____________________ List lists the database tables and the fields they contain.

Question 56

Use the ____________________ Form tool to create a form from scratch in Form Layout View.

Question 57

You can insert a logo on a form using the ____ button in the Controls group.

A) Graphic Art
B) Art
C) Graphic Image
D) Insert Image

Question 58

On a form, ____________________ View can be used to move and modify controls while viewing live data.

Question 59

Discuss layout positioning. Include the following terms in your response: margin, padding, and anchoring.

Question 60

Controls placed in the Form ____________________ print only once at the end of the last page of the printout.

Question 61

Match each term below with the statement that best defines it.
a.Command button
e.Tab control
b.Label
f.Combo box
c.Option button
g.Toggle button
d.List box
h.Line
Used to provide a list of options for a field plus the ability for the user to enter a new value

Question 62

Match each term below with the statement that best defines it.
a.Command button
e.Tab control
b.Label
f.Combo box
c.Option button
g.Toggle button
d.List box
h.Line
Creates a three-dimensional aspect on a form

Question 63

Match each term below with the statement that best defines it.
a.Command button
e.Tab control
b.Label
f.Combo box
c.Option button
g.Toggle button
d.List box
h.Line
Best choice to display a field such as Veteran that has only two options, Yes or No

Question 64

Match each term below with the statement that best defines it.
a.Command button
e.Tab control
b.Label
f.Combo box
c.Option button
g.Toggle button
d.List box
h.Line
Used to provide a list of possible data entries

Question 65

Match each term below with the statement that best defines it.
a.Command button
e.Tab control
b.Label
f.Combo box
c.Option button
g.Toggle button
d.List box
h.Line
Used to run a macro

Question 66

When you add a new field to a form, two controls are usually created: a(n) caption and a text box. _________________________

Question 67

Case 3-1
You are just starting to create a new form and have begun to realize that there are a variety of mouse pointer shapes in use. In order to make creating the form easier, you decide to familiarize yourself with a few of them.
Which of the following appears when you point to the upper-left corner or edge of a selected control in Form Design View or the middle of the control in Form Layout View?

A)
B)
C)
D)

Question 68

Match each term below with the statement that best defines it.
a.Command button
e.Tab control
b.Label
f.Combo box
c.Option button
g.Toggle button
d.List box
h.Line
Used to visually separate information on a form

Question 69

Match each term below with the statement that best defines it.
a.Command button
e.Tab control
b.Label
f.Combo box
c.Option button
g.Toggle button
d.List box
h.Line
Provides consistent descriptive text as you navigate records

Question 70

The connection between the text box and field is defined by the Control Source property. _________________________

Question 71

Case 3-1
You are just starting to create a new form and have begun to realize that there are a variety of mouse pointer shapes in use. In order to make creating the form easier, you decide to familiarize yourself with a few of them.
Which of the following appears when you point to one of the sizing handles (except the large one in the upper-left corner in Form Design View)?

A)
B)
C)
D) None of the above.

Question 72

The Navigation tab on the Property Sheet allows you to change the tab stop or tab order properties. _________________________

Question 73

Match each term below with the statement that best defines it.
a.Command button
e.Tab control
b.Label
f.Combo box
c.Option button
g.Toggle button
d.List box
h.Line
Displays choices for a field

Question 74

Case 3-1
You are just starting to create a new form and have begun to realize that there are a variety of mouse pointer shapes in use. In order to make creating the form easier, you decide to familiarize yourself with a few of them.
Which of the following displays when you point to any unselected control on the form?

A)
B)
C)
D)

Question 75

Case 3-1
You are just starting to create a new form and have begun to realize that there are a variety of mouse pointer shapes in use. In order to make creating the form easier, you decide to familiarize yourself with a few of them.
Which of the following is the default mouse pointer in Layout View?

A)
B)
C)
D)