Name: 
 

AccessUsingForms



True/False
Indicate whether the sentence or statement is true or false.
 

 1. 

A form is the primary object used to enter, edit, and find data.
 

 2. 

In a datasheet, sometimes all of the fields are not visible.
 

 3. 

A text box control is a bound control.
 

 4. 

A tab control is an unbound control.
 

 5. 

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

 6. 

Whether you create the form from scratch in Design View or by using the Form Wizard, you can modify it later if needed.
 

 7. 

Forms can be used to enter and edit data.
 

 8. 

A label is a bound control.
 

 9. 

By designing a form to match a source document, you facilitate fast and accurate data entry.
 

 10. 

Bound controls exist only to clarify or enhance the appearance of the form.
 
 
accessusingforms_files/i0120000.jpg
 

 11. 

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

 12. 

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

 13. 

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

 14. 

You can sort but not filter records using a form.
 

 15. 

You can modify a form that you have created using Form Design View, but those created by the Form Wizard cannot be modified later.
 

 16. 

A form contains Record Navigation buttons similar to those found on a datasheet.
 

 17. 

You can resize a form to be wider or narrower.
 

 18. 

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

 19. 

In Form Design View, the pointer that looks like an open black hand will move all selected controls.
 

 20. 

When you create a form with the Form Wizard, it places a list box to the left of each text box with the field's name.
 

 21. 

Text boxes are often used to clarify and describe bound labels.
 

 22. 

You can make property changes to a control through the menu and toolbar options.
 

 23. 

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

 24. 

In Form Design View, if you double-click the edge of a label you will open its property sheet.
 

 25. 

If you click in either the horizontal or vertical ruler in Form Design View, you will select all controls that intersect the selection line.
 

 26. 

The property sheet title bar tells you what type of control you are working with.
 

 27. 

Properties are listed in alphabetical order in the property sheet.
 

 28. 

A form has multiple sections which control how the form is displayed and printed.
 

 29. 

By default the Form Header section is not opened in Form Design View.
 

 30. 

By default, the Form Footer section is not opened in Form Design View.
 

 31. 

All controls created by the Form Wizard are placed in the Detail section.
 

Multiple Choice
Identify the letter of the choice that best completes the statement or answers the question.
 

 32. 

Which control, when "pressed" displays "yes" information?
a.
Bound image control
b.
Combo box
c.
Tab control
d.
Toggle button
 

 33. 

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
 

 34. 

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
 

 35. 

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
 

 36. 

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
 

 37. 

This control is used to create a three-dimensional aspect to a form and to organize other controls.
a.
Command button
b.
Toggle button
c.
Rectangle control
d.
Tab control
 

 38. 

This control is used to display OLE data.
a.
Option button
b.
Bound object frame
c.
Unbound image control
d.
OLE control
 

 39. 

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
 

 40. 

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
 

 41. 

Which of the following is NOT a bound control?
a.
Text box
b.
Combo box
c.
List box
d.
Label
 
 
accessusingforms_files/i0450000.jpg
 

 42. 

In the figure above, item 1 points to a(n) ____.
a.
Command button
b.
Option button
c.
Combo box
d.
Text box
 

 43. 

In the figure above, item 2 points to a(n) ____.
a.
Option button
b.
Label
c.
Combo box
d.
List box
 

 44. 

In the figure above, item 4 points to a(n) ____.
a.
Option button
b.
Option group
c.
Command button
d.
Check box
 

 45. 

In the figure above, item 3 points to the form's ____.
a.
View buttons
b.
Record navigation buttons
c.
Option buttons
d.
Control buttons
 

 46. 

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
 

 47. 

Which of the following is NOT a way to create a new form?
a.
Use the Create Wizard
b.
Use the AutoForm feature
c.
Use Form Design view
d.
Use the Form Wizard
 

 48. 

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
 

 49. 

You can move controls one pixel at a time by pressing ____ and an arrow key.
a.
[Spacebar]
b.
[Enter]
c.
[Shift]
d.
[Ctrl]
 

 50. 

You can resize controls one pixel at a time by pressing ____ and an arrow key.
a.
[Shift]
b.
[Ctrl]
c.
[Alt]
d.
[Tab]
 

 51. 

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
 

 52. 

In Form Design View, you use the white arrow pointer to ____ controls.
a.
Select
b.
Move
c.
Resize
d.
Add
 

 53. 

In Form Design View, point to the larger sizing handle in the upper-left corner of the selected control when you want to ____.
a.
Move all selected controls
b.
Resize all selected controls
c.
Move a single control
d.
Resize a single control
 

 54. 

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
 

 55. 

Click the ____ button in Form Design View to open the properties sheet for the chosen control.
a.
View
b.
Open
c.
Sheet
d.
Properties
 
 
accessusingforms_files/i0600000.jpg
 

 56. 

In the figure above, item 4 points to the ____ button.
a.
Field List
b.
Properties
c.
Selection
d.
Toolbox
 

 57. 

In the figure above, item 1 points to the ____.
a.
Field list
b.
Toolbox toolbar
c.
Horizontal ruler
d.
Form View button
 

 58. 

In the figure above, item 3 points to the ____ button.
a.
Toolbox
b.
Properties
c.
AutoFormat
d.
Form View
 

 59. 

When referencing field names within an expression, surround the field name with ____.
a.
[Square brackets]
b.
{Curly brackets}
c.
(Parentheses)
d.
"Quotation marks"
 

 60. 

You can press [Tab] or ____ to move the focus through the controls of the form.
a.
[Page Down]
b.
[Enter]
c.
[F5]
d.
[F12]
 

 61. 

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
 

 62. 

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
 

 63. 

Which of the following would NOT be considered a graphic image?
a.
Picture
b.
Logo
c.
Text
d.
Clip art
 

 64. 

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
 

Completion
Complete each sentence or statement.
 

 65. 

A(n) ____________________ is an Access database object that allows you to arrange the fields of a record in any layout.
 

 

 66. 

Use the ____________________ button control if you have a limited list of possible choices for a field.
 

 

 67. 

The ____________________ control will create a three-dimensional aspect to a form so that other controls can be organized.
 

 

 68. 

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

 

 69. 

The bound ____________________ box control allows you to choose from a list of possible data entries or enter a value from the keyboard.
 

 

 70. 

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

 

 71. 

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

 

 72. 

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

 

 73. 

The ____________________ source for a form is either a table or query object.
 

 

 74. 

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

 

 75. 

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

 

 76. 

Forms are often built to match a ____________________ document.
 

 

 77. 

Form ____________________ are used to display and enter data.
 

 

 78. 

____________________ controls display data from the underlying records source.
 

 

 79. 

____________________ controls do not change from record to record.
 

 

 80. 

The unbound ____________________ control provides descriptive text.
 

 

 81. 

A ____________________ box control is the most common type of bound control.
 

 

 82. 

The ____________________ feature offers no prompts or dialog boxes. It instantly creates a form that displays all the fields in the chosen table or query.
 

 

 83. 

To create a form without the use of a wizard, use Form ____________________ View.
 

 

 84. 

In Form Design View, the ____________________ list contains the fields in the record source.
 

 

 85. 

In Form Design View, a selected control will display squares, called ____________________ handles, on its corners and edges.
 

 

 86. 

If you make a mistake in Form Design View, click the ____________________ button to reverse the action.
 

 

 87. 

You would modify the size, location, and appearance of controls in Form ____________________ View.
 

 

 88. 

The ____________________ toolbar contains buttons that allow you to add controls to the form.
 

 

 89. 

In Form View, a horizontal and vertical ____________________ help you measure and place the location of controls.
 

 

 90. 

The ____________________ tab on the property sheet for a label control displays the Caption property value.
 

 

 91. 

To change the text shown by a label, you can directly edit it in Form Design View, or you can modify its ____________________ property.
 

 

 92. 

The ____________________ sheet is a comprehensive listing of all properties (characteristics) that have been specified for that control.
 

 

 93. 

To create a calculation in a text box, you enter a(n) ____________________ to calculate a result.
 

 

 94. 

Text boxes are generally used to display data from underlying fields and are therefore ____________________ to that field.
 

 

 95. 

The ____________________ order is the order in which the focus moves as you press [Tab] in Form View.
 

 

 96. 

In Form View, ____________________ refers to which field would be edited if you started typing.
 

 

 97. 

____________________ images, such as pictures, a logo, or clip art, can be added to a form.
 

 



 
Check Your Work     Reset Help