Deck 7: Advanced Form Techniques

Question 1

To change the appearance of a santrol so that it appears sunken, change the ____ property for the santrol.

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

Answer 1

C

Question 2

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

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

Answer 2

C

Question 3

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

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

Answer 3

C

Question 4

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

A) santrol Source
B) Row Source
C) Resard Source
D) Table Source

Question 5

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 6

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

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

Question 7

To change the appearance of a santrol so that text in the santrol displays in a different salor, change the ____ property for the santrol.

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

Question 8

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 9

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 10

To sapy the formatting of one santrol to other santrols, use the ____ button on the FORM DESIGN TOOLS FORMAT tab.

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

Question 11

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 santrols group.

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

Question 12

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

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

Question 13

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

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

Question 14

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

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

Question 15

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

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

Question 16

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

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

Question 17

To activate a wizard to help in creating sambo boxes and sammand buttons, make sure the ____ button is selected.

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

Question 18

One way to locate resards 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 19

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 20

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

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

Question 21

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

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

Question 22

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

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

Question 23

To change the name for a santrol, change the ____ property on the property sheet.

A) santrol Source
B) Caption
C) Resard Source
D) Name

Question 24

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

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

Question 25

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 26

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 27

The SubForm Wizard displays in the acsampanying 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 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 insert a tab santrol on a form, tap or click the ____ tool on the FORM DESIGN TOOLS DESIGN tab in the santrols group.

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

Question 30

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

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

Question 31

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

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

Question 32

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

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

Question 33

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 sade

Question 34

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

A) sancatenated Field
B) Text Box
C) Add santrol
D) Build

Question 35

The SubForm Wizard displays in the acsampanying 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 santrol Wizards
D) Select Wizard

Question 36

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

A) MoveFocus
B) GoTosantrol
C) Focus
D) SeTFQocus

Question 37

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

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

Question 38

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 39

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

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

Question 40

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

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

Question 41

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

Question 42

The form in the acsampanying 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 43

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 44

The form in the acsampanying figure includes sammand buttons and a sambo box. If a form includes a Delete Resard button, tapping or clicking the button will delete the resard currently on the screen without asking the user to verify the deletion.

Question 45

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

Question 46

Modified Multiple Choice The categories of actions available for sammand buttons are ____.

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

Question 47

The form in the acsampanying figure includes sammand buttons and a sambo box. To select an entry from a sambo box, press the TAB key.

Question 48

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

Question 49

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

Question 50

sambo boxes also are called drop-down boxes.

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 Resard Navigation category includes the ____ actions.

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

Question 53

The form in the acsampanying 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 54

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

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

Question 55

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

Question 56

The form in the acsampanying 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 57

A sammand button can display either text or a picture.

Question 58

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

Question 59

The form in the acsampanying figure includes sammand buttons and a sambo box. If a form includes an Add Resard button, tapping or clicking the button will clear the santents of the form so you can add a new resard.

Question 60

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 61

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

Question 62

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

Question 63

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

Question 64

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

Question 65

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

Question 66

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

Question 67

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

Question 68

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

Question 69

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

Question 70

santrol names in macros can santain spaces.

Question 71

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

Question 72

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

Question 73

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

Question 74

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

Question 75

The form in the acsampanying figure includes sammand buttons and a sambo box. When you create an Add Resard sammand button using the sammand Button Wizard, the button automatically places an insertion point in the first field on the form.

Question 76

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

Question 77

A sambo box sambines the properties of a text box and a list box.

Question 78

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

Question 79

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

Question 80

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