Deck 4: Access: Advanced Form Techniques

Question 1

To add an image to a form, open the form in Layout or Design view and tap or click the ____ button on the FORM DESIGN TOOLS DESIGN tab in the Controls group.

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

Answer 1

D

Question 2

When you change the font color using the ribbon, you tap or click the ____ button.

A) Change Color
B) Text
C) Font Color
D) Foreground

Answer 2

C

Question 3

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

Answer 3

C

Question 4

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

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

Question 5

To add a Form Header section and a title to a form, tap or click the ____ button on the FORM DESIGN TOOLS DESIGN tab.

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

Question 6

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 7

To add a background image to a form, tap or click anywhere in the form and then tap or click ____ on the FORM DESIGN TOOLS FORMAT tab in the Background group.

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

Question 8

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

A) DESIGN
B) HOME
C) DATABASE TOOLS
D) FILE

Question 9

To add command buttons to a form, use the ____ tool on the FORM DESIGN TOOLS DESIGN tab in the Controls group.

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

Question 10

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 11

To copy the formatting of one control to other controls, use the ____ button on the FORM DESIGN TOOLS FORMAT tab.

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

Question 12

To add a combo box to a form, use the ____ tool in the Controls group on the FORM DESIGN TOOLS DESIGN tab.

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

Question 13

To display a field list, tap or click the ____ button on the FORM DESIGN TOOLS DESIGN tab in the Tools group.

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

Question 14

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

Question 15

To change the background color of a form header, tap or click anywhere in the Form Header section but outside all the controls and then tap or click the ____ button arrow on the FORM DESIGN TOOLS FORMAT tab in the Font group.

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

Question 16

To create a form in Design view, tap or click the CREATE tab, and then tap or click the ____ button.

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

Question 17

To change the caption for a form, use the ____ property in the property sheet.

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

Question 18

To select a table as the basis for a form, display the property sheet and tap or click the ____ arrow.

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

Question 19

To change the background color of a form, tap or click anywhere in the Detail section but outside all the controls and then tap or click the ____ arrow on the FORM DESIGN TOOLS FORMAT tab in the Font group.

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

Question 20

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 21

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 22

To modify a macro associated with a command button, press and hold or right-click the command button and tap or click ____ on the shortcut menu.

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

Question 23

To add a concatenated field to a form, use the ____ tool in the Controls group on the FORM DESIGN TOOLS DESIGN tab.

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

Question 24

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

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

Question 25

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 26

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

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

Question 27

The SubForm Wizard displays in the accompanying figure. To add a subform to a form, you use the ____ tool on the FORM DESIGN TOOLS DESIGN tab in the Controls group.

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

Question 28

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

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

Question 29

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 30

To change the order of tab controls, press and hold or right-click any tab control and tap or click ____ on the shortcut menu.

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

Question 31

To change the On Current property for a form, tap or click the form selector for the form, tap or click the ____ button on the FORM DESIGN TOOLS DESIGN tab in the Tools group, and then tap or click the On Current property.

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

Question 32

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

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

Question 33

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

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

Question 34

To sign out of a Microsoft account, tap or click FILE on the ribbon to open the Backstage view and then tap or click the ____ tab.

A) Info
B) Options
C) Account
D) Share

Question 35

To open a form, press and hold or right-click the form in the Navigation Pane, and tap or click ____ on the shortcut menu.

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

Question 36

To insert a chart in a form, use the ____ tool on the FORM DESIGN TOOLS DESIGN tab.

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

Question 37

To place a rectangle around a combo box, use the ____ tool on the FORM DESIGN TOOLS DESIGN tab in the Controls group.

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

Question 38

To insert a tab control on a form, tap or click the ____ tool on the FORM DESIGN TOOLS DESIGN tab in the Controls group.

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

Question 39

To display a property sheet, tap or click the ____ button on the FORM DESIGN TOOLS DESIGN tab in the Tools group.

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

Question 40

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

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

Question 41

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 42

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 FORM DESIGN TOOLS DESIGN tab will add both a Form Header section and a title.

Question 43

Modified Multiple Choice The Record Navigation category includes the ____ actions.

A) Add New Record
B) Go To Next Record
C) Go To Previous Record
D) Close Form

Question 44

To change the background color of a form, use the Background Color button on the FORM DESIGN TOOLS FORMAT tab.

Question 45

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

Question 46

Modified Multiple Choice You can include a background image in a form by opening the form in ____ view.

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

Question 47

Modified Multiple Choice You can include an image in a form by opening the form in ____ view.

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

Question 48

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

Question 49

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 50

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

Question 51

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 52

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 53

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

Question 54

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 55

Combo boxes also are called drop-down boxes.

Question 56

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

Question 57

Modified Multiple Choice The Record Operations category includes the ____ actions.

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

Question 58

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

Question 59

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

Question 60

A command button can display either text or a picture.

Question 61

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

Question 62

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

Question 63

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

Question 64

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.

Question 65

You can convert macros that are attached to forms to VBA (Visual Basic for Applications) code.

Question 66

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 67

To display the on-screen touch keyboard, tap the Touch Keyboard button on the status bar .

Question 68

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 69

You can change titles, legends, and labels for a chart by using the Graph Properties command.

Question 70

To create a new form in Design view, tap or click the ____________________ button on the CREATE tab.

Question 71

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

Question 72

To align command buttons, use the buttons on the FORM DESIGN TOOLS DESIGN tab.

Question 73

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

Question 74

Control names in macros can contain spaces.

Question 75

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

Question 76

To insert a chart, use the Chart tool on the FORM DESIGN TOOLS DESIGN tab.

Question 77

To insert a chart, use the Graph Object tool on the FORM DESIGN TOOLS DESIGN tab.

Question 78

A combo box combines the properties of a text box and a list box.

Question 79

The Format Chart Area command allows you to change the border style, color, fill effects, and fonts for a chart.

Question 80

A(n) ____________________ form is a form that contains more than one page of information.