Deck 13: Access 2007 Unit C: Using Forms

Question 1

This control is both a list box and a text box control.

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

Answer 1

C

Question 2

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

Answer 2

True

Question 3

This control is used to create a three-dimensional aspect to a form.

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

Answer 3

D

Question 4

Which of the following is NOT a bound control?

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

Question 5

A form contains Record Navigation buttons, with information about the current record number and total number of records, similar to those found on a datasheet.

Question 6

A text box control is a bound control.

Question 7

A tab control is an unbound control.

Question 8

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

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

Question 9

This control is used to display "yes" or "no" answers for a field.

A) Check box
B) List box
C) Combo box
D) Option box

Question 10

Forms can be used to enter and edit data.

Question 11

This 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 12

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

Question 13

This 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 14

This control is used to display OLE data.

A) Option button
B) Bound object frame
C) Unbound image control
D) OLE control

Question 15

This 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 16

In the figure above, item 4 points to option button controls.

Question 17

This control is used to display, edit, or enter data for each record. It does not provide a list of possible data entries.

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

Question 18

Form Design View allows you to add, but not delete, controls.

Question 19

In the figure above, item 3 points to the combo box control.

Question 20

In the figure above, item 1 points to text box controls.

Question 21

After making modifications in Form Design View, click the ____ View button to view the form and enter data.

A) Object
B) Database
C) Form
D) Preview

Question 22

You can resize controls one pixel at a time by pressing ____ and an arrow key.

A) [Shift]
B) [Ctrl]
C) [Alt]
D) [Tab]

Question 23

Which type of control would you most likely use to display first name information?

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

Question 24

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

A) field name
B) option button
C) combo box
D) text box

Question 25

Which technique would you use to select several controls in Form Design View?

A) Click, [Shift]+click
B) Click, [Alt]+click
C) Click, [Ctrl]+click
D) Click, [Tab]+click

Question 26

In the figure above, item 7 points to the ____.

A) Field List button
B) Ascending button
C) vertical ruler
D) Descending button

Question 27

In Form Design View, you use the white arrow pointer to ____ controls.

A) Select
B) Move
C) Resize
D) Add

Question 28

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

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

Question 29

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

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

Question 30

In the figure above, item 4 points to a(n) ____.

A) option button
B) option group
C) command button
D) New record button

Question 31

In the figure above, item 5 points to a(n) ____.

A) combo box
B) record navigation button
C) option button
D) text box

Question 32

In the figure above, item 2 points to ____.

A) option buttons
B) labels
C) combo boxes
D) list boxes

Question 33

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

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

Question 34

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

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

Question 35

Which of the following is NOT a way to create a new form?

A) Create Wizard
B) Form Design View
C) Form Wizard
D) All of the above

Question 36

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

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

Question 37

Bound object frame controls are used to display data from a field defined with what data type?

A) Text
B) Memo
C) Image
D) OLE Object

Question 38

In Form Design View, double-click a sizing handle of the selected label when you want to ____.

A) move all selected controls
B) resize all selected controls
C) resize the label to fit the entire caption
D) rename the label

Question 39

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 40

In the figure above, item 8 points to the ____.

A) field names
B) properties
C) selections
D) toolboxes

Question 41

The ____________________ object frame control displays OLE data, such as a picture.

Question 42

In Form Design View, the ____________________ List contains the database tables and fields from the record source.

Question 43

To change the text shown by a label, you can modify its ____________________ property.

Question 44

Differentiate between label and text box controls.

Question 45

Discuss the difference between tab order and tab stop.

Question 46

The ____________________ button control displays "yes" or "no" answers for a field.

Question 47

Differentiate between bound and unbound controls.

Question 48

The ____________________ button control provides an easy way to run a macro.

Question 49

You would modify fonts and colors in Form ____________________ View.

Question 50

The ____________________ Sheet is a comprehensive listing of all characteristics that have been specified for that control.

Question 51

____________________ controls are used to display and edit data on a form.

Question 52

Matt Jeffries is a database designer at Quest Specialty Travel. He has used the main Tours database to isolate and analyze Adventure tours that occur in Colorado. Matt needs to add a text box to calculate these tours end dates in a form. Which View should he select?

Question 53

You would use line and rectangle controls to add data to a form.

Question 54

In Form Design View, the pointer that looks like a white arrow will move records.

Question 55

By default, only the first text box in a form has a tab stop and is placed in the tab order.

Question 56

The only way to select all controls that intersect the selection line is to click in the horizontal ruler.

Question 57

A calculation can begin with a , >, or equal sign .

Question 58

The ____________________ object frame displays a picture or clip art that doesn't change as you navigate from record to record.

Question 59

____________________ images, such as pictures, can be added to a form.

Question 60

Matt Jeffries is a database designer at Quest Specialty Travel. He has used the main Tours database to isolate and analyze Adventure tours that occur in Colorado. Show the expression Matt should enter to calculate each tour s end date.

Question 62

Matt Jeffries is a database designer at Quest Specialty Travel. He has used the main Tours database to isolate and analyze Adventure tours that occur in Colorado. Matt has been asked to add Quest s logo to the top of the form to print only once if the form is printed. In which section should he add it?

Question 63

Matt Jeffries is a database designer at Quest Specialty Travel. He has used the main Tours database to isolate and analyze Adventure tours that occur in Colorado. Matt s boss wants him to insert an image of the state of Colorado for each record. In which section should he add this image?