Deck 9: Advanced Form Techniques

Question 1

If a Security Warning appears when you open a database, click the ____ option button.

A) Customize
B) Enable Content
C) Security
D) Warning

Answer 1

B

Question 2

To change the appearance of a control so that text in the control displays as semi-bold, change the _____ property for the control.

A) Font
B) Format
C) Font Weight
D) Special Effect

Answer 2

C

Question 3

To add a background image to a form, click anywhere in the form and then click _____ on the Format tab in the Background group.

A) Watermark
B) Unbound Image
C) Picture
D) Background Image

Answer 3

D

Question 4

To display a field list, click the _____ button on the Design tab in the Tools group.

A) Field List
B) Show Fields
C) Show/Hide Field List
D) Add Existing Fields

Question 5

If you use the property sheet to change the font color for a control, click the _____ property.

A) Color
B) Font
C) Fore Color
D) Foreground

Question 6

To copy the formatting of one control to other controls, use the _____ button on the Format tab.

A) Copy Format
B) Copy
C) Format Painter
D) Redo

Question 7

To add command buttons to a form, use the _____ tool in the Controls group on the Design tab.

A) Option Button
B) Bound Object Frame
C) Command Button
D) Button

Question 8

To select a table as the basis for a form, display the property sheet and click the _____ property.

A) Control Source
B) Row Source
C) Record Source
D) Table Source

Question 9

With a(n) _____, you can enter a value either by typing the value or by selecting it from a list.

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

Question 10

To change the appearance of a control so that it appears sunken, change the _____ property for the control.

A) Format
B) Style
C) Special Effect
D) Font

Question 11

To change the appearance of a control so that text in the control displays in a different color, change the _____ property for the control.

A) Font
B) Format
C) Fore Color
D) Text Color

Question 12

To change the background color of a form header, click anywhere in the Form Header section but outside all the controls and then click the _____ button arrow on the Format tab in the Font group.

A) Header Color
B) Change Color
C) Background Color
D) Section Color

Question 13

To place a rectangle around a combo box, use the _____ tool in the Controls group on the Design tab.

A) Line
B) Rectangle
C) Bound Object Frame
D) Unbound Object Frame

Question 14

To ensure that a combo box will appear within a rectangle, change the _____ property to Transparent.

A) Format
B) Special Effects
C) Color
D) Back Style

Question 15

To activate a wizard to help in creating combo boxes and command buttons, make sure the _____ button is selected.

A) Wizard
B) Use Control Wizards
C) Tool Wizard
D) Select Wizard

Question 16

To add a Form Header section and a title to a form, click the _____ button on the Design tab.

A) Form Header/Title
B) Title
C) Form Header
D) Label

Question 17

To create a form from scratch, click the Create tab, and then click the _____ button.

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

Question 18

To add a combo box to a form, use the _____ tool in the Controls group on the Design tab.

A) List/Text Box
B) Unbound Object Frame
C) Text Box
D) Combo Box

Question 19

To change the caption for a form, use the _____ property.

A) Name
B) Modal
C) Control Source
D) Caption

Question 20

One way to locate records on a form is to use the Find button on the _____ tab in the Find group.

A) File
B) Home
C) Database Tools
D) Design

Question 21

To open a form, right-click the form in the Navigation Pane, and click _____ on the shortcut menu.

A) Form View
B) Open
C) View
D) Display View

Question 22

To change the order of tab controls, right-click any tab control and click _____ on the shortcut menu.

A) Change Order
B) Tab Order
C) Page Order
D) Reorder

Question 23

To change the name for a control, change the _____ property on the property sheet.

A) Control Source
B) Caption
C) Record Source
D) Name

Question 24

The SubForm Wizard displays in the accompanying figure. To add a subform to a form, you use the _____ tool on the Design tab.

A) Form
B) Subform
C) Bound Object Frame
D) Subform/Subreport

Question 25

To insert a chart in a form, use the _____ tool on the Design tab.

A) Charts & Graphs
B) Chart
C) Charts, Graphs, & Pictures
D) Bound Object

Question 26

To insert a tab control on a form, click the _____ tool on the Design tab in the Controls group.

A) Unbound Object Frame
B) Bound Object Frame
C) Page Control
D) Tab Control

Question 27

To add an image to a form, open the form in Layout or Design view and click the _____ button on the Design tab in the Controls group.

A) Picture
B) Add Picture
C) Add Image
D) Insert Image

Question 28

A(n) _____ is a series of actions that Access performs when a particular event occurs.

A) argument
B) task
C) procedure
D) macro

Question 29

The SubForm Wizard displays in the accompanying figure. To open a subform in Design view, right-click the subform in the Navigation Pane and click _____ on the shortcut menu.

A) Subform View
B) Modify Subform
C) Design View
D) Subform Design

Question 30

To remove the field list when working on a form in Design view, click the _____ button on the Design tab in the Tools group.

A) Add Existing Fields
B) Show/Hide Fields
C) Remove Fields
D) Field List

Question 31

To change a chart type, right-click the chart in Design view, point to Chart Object on the shortcut menu, and then click _____ on the Chart Object submenu.

A) Edit
B) Change
C) Modify
D) Design

Question 32

A control is said to have the _____ when it becomes active; that is, when it becomes able to receive user input through mouse or keyboard actions.

A) currency
B) center
C) immediacy
D) focus

Question 33

To modify a macro associated with a command button, right-click the command button and click _____ on the shortcut menu.

A) Build Event
B) Macro Window
C) Change To
D) Macro Design

Question 34

To add gridlines to a form, use the _____ button on the Arrange tab in the Table group.

A) Tabular
B) Lines
C) Gridlines
D) Align

Question 35

To change the On Current property for a form, click the form selector for the form, click the _____ button on the Design tab, and then click the On Current property.

A) Form Properties
B) Event Properties
C) Property Sheet
D) VBA Code

Question 36

The SubForm Wizard displays in the accompanying figure. To ensure that the wizard guides you through the process of adding a subform, make sure the _____ button is selected.

A) Wizard
B) Wizard & Tools
C) Use Control Wizards
D) Select Wizard

Question 37

To display a property sheet, click the _____ button on the Design tab.

A) Property Sheet
B) Show/Hide Property Sheet
C) Add Property Sheet
D) Properties

Question 38

To modify the query that Access creates for a combo box, click the Row Source property for the combo box and then click the _____ button.

A) Query
B) Query Design
C) Build
D) Expression Builder

Question 39

The _____ macro action will move the focus to a specific control.

A) MoveFocus
B) GoToControl
C) Focus
D) SetFocus

Question 40

To add a calculated field to a form, use the _____ tool in the Controls group on the Design tab.

A) Calculated Field
B) Text Box
C) Add Control
D) Build

Question 41

The Form Wizard and the Form button are two of several tools that you can use to create a form.

Question 42

The form in the accompanying figure is open in Design view. To view the form in Form view, click the Form view button on the Status bar.

Question 43

To copy a format to more than one control, hold the SHIFT key down when clicking the Format Painter button.

Question 44

You can change the spacing within a layout by changing the control margins to _____.

A) None
B) Narrow
C) Medium
D) Wide

Question 45

Combo boxes also are called drop-down boxes.

Question 46

Once you have formatted a control and its label the way you want, you can format other controls in exactly the same way by using the format painter.

Question 47

The form in the accompanying figure includes command buttons and a combo box. If a form includes an Add Record button, clicking the button will clear the contents of the form so you can add a new record.

Question 48

If #Name to Find is entered as the label for a combo box, users can select the combo box by pressing ALT+N.

Question 49

A command button can display either text or a picture.

Question 50

The form in the accompanying figure includes command buttons and a combo box. To select an entry from a combo box, press the TAB key.

Question 51

The Record Operations Category includes the _____ Actions.

A) Add Record
B) Go To First Record
C) Delete Record
D) Close Form

Question 52

To change the background color of a form, use the Background Color button on the Format tab.

Question 53

The form in the accompanying figure has no title. When you add a title to a form using the Title button, Access uses the name of the object instead of the caption as the title.

Question 54

The Record Navigation Category includes the _____ Actions.

A) Find Next
B) Go To First Record
C) Go To Last Record
D) Close Form

Question 55

You can create _____ layouts for forms or reports.

A) top down
B) stacked
C) tabular
D) side-by-side

Question 56

The form in the accompanying figure includes command buttons and a combo box. If a form includes a Delete Record button, clicking the button will delete the record currently on the screen without asking the user to verify the deletion.

Question 57

Modified Multiple Choice The categories of actions available for command buttons are _____.

A) Record Navigation
B) Macro Operations
C) Record Operations
D) Form Operations

Question 58

A combo box only allows users to select entries from a list.

Question 59

The form in the accompanying figure has no title. If a form currently does not have a Form Header section, clicking the Title button on the Design tab will add both a Form Header section and a title.

Question 60

When you change the caption for a form, the name on the tab changes to the new caption in both Form view and Design view.

Question 61

If you create a form using the Form button on the Create tab, Access automatically creates a tabular layout.

Question 62

A(n) ____________________ combines the properties of a text box and a list box.

Question 63

To change the spacing around the outside of a control, change the control margins .

Question 64

Once you have formatted a control and its label the way you want, you can format other controls in exactly the same way by using the ____________________.

Question 65

To change the spacing around the text inside a control, change the control margins .

Question 66

To insert a chart, use the Graph Object tool on the Design tab.

Question 67

The form in the accompanying figure includes command buttons and a combo box. As you type a name to find in a combo box, Access will display automatically the name that begins with the letters you have typed.

Question 68

When the Control Wizard is used to create a combo box, the values in the combo box are sorted automatically.

Question 69

Names in Visual Basic for Applications can contain spaces.

Question 70

A combo box combines the properties of a text box and a(n) ____________________ box, a box you can use to display a list.

Question 71

You can split a cell horizontally but not vertically.

Question 72

To insert a chart, use the Chart tool on the Design tab.

Question 73

To change the order of tab controls on a form, right-click any tab control and click Tab Order on the shortcut menu.

Question 74

To ensure the data is sorted in the correct order, you change the Row Sourc e property for the combo box.

Question 75

One way to change the focus from one field to another is to press the TAB key.

Question 76

A combo box combines the properties of a(n) ____________________ box, a box into which you can type an entry, and a list box.

Question 77

To merge cells in a control layout, select the cells to be merged and then click the Merge button on the Format tab.

Question 78

The accompanying figure shows command buttons on a form. The action for the Next Record button is Go To Next Record, which is in the ____________________ category.

Question 79

The On Current event property ensures that the combo box is kept current for the rest of the form and is a property of the combo box control.

Question 80

The form in the accompanying figure includes command buttons and a combo box. When you create an Add Record command button using the Command Button Wizard, the button automatically places an insertion point in the first field on the form.