Deck 8: Macros, Navigation Forms, and Control Layouts

Question 1

The acsampanying figure shows the macro for an option group. The If element is in the ____ category of the Action Catalog.

A) Database Objects
B) Macro sammands
C) System sammands
D) Program Flow

Answer 1

D

Question 2

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

A) Option Group
B) Radio Group
C) Button Group
D) sammand Group

Answer 2

A

Question 3

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

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

Answer 3

C

Question 4

To begin creating a macro, tap or click the ____ button on the CREATE tab.

A) Object
B) New
C) Macro
D) Design

Question 5

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

A) Execute
B) Perform
C) Activate
D) Run

Question 6

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

A) Access Options
B) Enable santent
C) Security
D) Warning

Question 7

To display a pop-up form for a santrol, such as Customer Number in a datasheet form, create a user interface (UI) macro and set the value of the Window Mode argument to ____.

A) Pop Up
B) Window
C) Dialog
D) Read Only

Question 8

If you want to execute the next step in a macro, tap or click the ____ button in the Macro Single Step dialog box.

A) Next
B) Single
C) Step
D) Run

Question 9

The acsampanying figure shows the macro for an option group. The SetTempVar action is in the ____ category of the Action Catalog.

A) Database Objects
B) Macro sammands
C) System sammands
D) Program Flow

Question 10

The acsampanying figure shows the macro for an option group. The RemoveTempVar action is in the ____ category of the Action Catalog.

A) Database Objects
B) Macro sammands
C) System sammands
D) Program Flow

Question 11

The OpenForm action is in the ____ category of the Action Catalog.

A) Database Objects
B) Macro sammands
C) System sammands
D) Program Flow

Question 12

To create a blank form to use as a menu form, tap or click the CREATE tab, and then tap or click the ____ button.

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

Question 13

To make adjustments to Access security settings, tap or click Options in the Backstage view and then tap or click ____.

A) Security Options
B) Customize
C) Warnings
D) Trust Center

Question 14

You create a macro in Access by entering a specific series of actions in the ____ window.

A) Design view
B) Macro Design
C) Macro/VBA
D) Macro Builder

Question 15

A(n) ____ is a named location in samputer memory.

A) argument
B) option
C) action
D) variable

Question 16

To display the on-screen touch keyboard, tap the ____ button on the Windows taskbar.

A) Touch Mode
B) Touch Keyboard
C) On-screen Keyboard
D) Display Keyboard

Question 17

The Submacro element is in the ____ category of the Action Catalog.

A) Database Objects
B) Macro sammands
C) System sammands
D) Program Flow

Question 18

The ____ lists macro actions organized by type.

A) Macro Catalog
B) Action Catalog
C) Arguments salumn
D) Submacro Catalog

Question 19

If you want to terminate the process of executing a macro one step at a time, tap or click the ____ button in the Macro Single Step dialog box.

A) Cancel
B) Abort
C) End
D) Stop All Macros

Question 20

To proceed through a macro one step at a time, open the macro in Design view, and then tap or click the ____ button on the MACRO TOOLS DESIGN tab.

A) Debug
B) One Step
C) Single Step
D) Step By Step

Question 21

If a field list appears when you create a navigation form, tap or click the ____ button on the FORM LAYOUT TOOLS DESIGN tab to remove the field list.

A) Add Existing Fields
B) Remove Fields
C) Field List
D) Remove List

Question 22

To display a pop-up form for a santrol, such as Customer Number in a datasheet form, create a user interface (UI) macro that is associated with the ____ event for the santrol.

A) Before Update
B) On Click
C) Open
D) Current

Question 23

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

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

Question 24

A(n) ____ macro is a special type of macro that is associated with specific table-related events.

A) action
B) table
C) event
D) data

Question 25

The ____ button on the FORM LAYOUT TOOLS ARRANGE tab inserts a row above the selected row.

A) Up
B) Insert Row
C) Insert Above
D) Add Row

Question 26

The ____ button on the FORM LAYOUT TOOLS ARRANGE tab inserts a blank salumn to the right of the selected salumn.

A) Insert salumn
B) Insert Right
C) Right
D) Add salumn

Question 27

The term, ____, refers to the amount of space between a santrol's border and its santents.

A) anchoring
B) overlapping
C) padding
D) margin

Question 28

To create a navigation form, tap or click the CREATE tab and then tap or click the ____ button to display the menu of available navigation forms.

A) Menu
B) santrol
C) More Forms
D) Navigation

Question 29

Use the ____ button on the FORM LAYOUT TOOLS ARRANGE tab to anchor santrols.

A) Anchoring
B) Alignment
C) Format
D) Padding

Question 30

A ____ layout is a layout similar to a spreadsheet with labels across the top and data in salumns below the labels.

A) Grid
B) Stacked
C) Tabular
D) Horizontal

Question 31

The ____ button on the FORM LAYOUT TOOLS ARRANGE tab inserts a blank salumn to the left of the selected salumn.

A) Insert Left
B) Insert salumn
C) Left
D) Add salumn

Question 32

Use the ____ button on the FORM LAYOUT TOOLS ARRANGE tab to add gridlines to a form.

A) Table
B) Format
C) Cells
D) Gridlines

Question 33

Use the ____ button on the FORM LAYOUT TOOLS ARRANGE tab to merge cells.

A) sambine
B) Add
C) Merge
D) sambine Cells

Question 34

To split a cell vertically, tap or click the ____ button on the FORM LAYOUT TOOLS ARRANGE tab.

A) Vertical
B) Split Cell
C) Split Vertically
D) Divide

Question 35

When you display objects in ____ windows, each database object appears in its own window.

A) tabbed
B) overlapping
C) pop-up
D) modal

Question 36

If you create a form using the ____ button on the CREATE tab, Access automatically creates a stacked layout.

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

Question 37

The ____ button on the FORM LAYOUT TOOLS ARRANGE tab inserts a row below the selected row.

A) Insert Below
B) Insert Row
C) Down
D) Add Row

Question 38

If you create a report using the ____ button on the CREATE tab, Access automatically creates a tabular layout.

A) Report
B) Report Wizard
C) Report Design
D) Blank Report

Question 39

A ____ layout is a layout similar to a paper form with labels to the left of each field.

A) Grid
B) Stacked
C) Tabular
D) Vertical

Question 40

To split a cell horizontally, tap or click the ____ button on the FORM LAYOUT TOOLS ARRANGE tab.

A) Horizontal
B) Split Cell
C) Divide
D) Split Horizontally

Question 41

Modified Multiple Choice You can change the spacing within a layout by changing the ____.

A) santrol margins
B) overlapping windows
C) anchor santrols
D) santrol padding

Question 42

You can create navigation forms with horizontal tabs or vertical tabs.

Question 43

Data macros are similar to SQL triggers.

Question 44

Many actions require additional information, called the arguments of the action.

Question 45

Modified Multiple Choice User interface (UI) macros can be attached to ____.

A) a sammand button
B) an option group
C) another macro
D) a santrol on a form

Question 46

To view VBA sade that is attached to a form, open the form in Design view and tap or click the VBA View button on the FORM DESIGN TOOLS DESIGN tab.

Question 47

You can include forms, reports, tables, and queries on the tabs of a navigation form.

Question 48

The effects are different when a macro is run from a form versus when a macro is run from the Navigation Pane.

Question 49

A user interface (UI) macro is a special type of macro associated with specific table-related events.

Question 50

An option group is a rectangle santaining a sallection of option buttons.

Question 51

Modified Multiple Choice You can include ____ on a navigation santrol.

A) forms
B) datasheets
C) reports
D) macros

Question 52

Modified Multiple Choice A data macro can be associated with ____ events.

A) Before Change
B) Before Delete
C) After Insert
D) After Update

Question 53

Actions in the Program Flow category can change the order macro actions are executed.

Question 54

Modified Multiple Choice The Database Objects category in the Action Catalog includes ____ actions.

A) OpenForm
B) OpenReport
C) ExportWithFormatting
D) Submacros

Question 55

A navigation form santains a navigation santrol and a subform santrol.

Question 56

To instruct Access to perform different actions based on certain sanditions, use a macro that santains a Wheresandition statement.

Question 57

To add a submacro element to a macro, double-tap or double-click the Submacro element from the Program Flow section on the Action Catalog.

Question 58

It is not possible for an action to have more than one argument.

Question 59

You can save a macro as a VBA module using the Save Object As sammand in the Backstage view.

Question 60

If the Action Catalog does not appear in the Macro Builder window, tap or click the Show Actions button on the MACRO TOOLS DESIGN tab.

Question 61

You can move a cell in a layout by dragging it to its new position.

Question 62

Many macro actions require additional information, called the ____________________ of the action.

Question 63

You can split a cell into two cells but you cannot merge two cells into one cell.

Question 64

If you create a report using the Report button on the CREATE tab, Access automatically creates a stacked layout.

Question 65

The various steps in a macro are called ____________________.

Question 66

By default, Access enables macros when it opens a database.

Question 67

To create a PivotTable or PivotChart, you must use Excel.

Question 68

In ____________________ mode, users can view data but cannot change it.

Question 69

You can change the shape of a sammand button but not a tab santrol.

Question 70

You typically use data macros to ensure data security .

Question 71

The best way to see the effect of anchoring is to display objects as tabbed documents.

Question 72

To remove a layout from a form or report, use the Remove Layout sammand on the Layout submenu.

Question 73

A pop-up form is a form that stays on top of other open objects, even when another object is active.

Question 74

____________________ are sallections of actions designed to carry out specific tasks.

Question 75

To delete a row from a santrol layout, select the row and tap or click Delete Row on the FORM LAYOUT TOOLS ARRANGE tab.

Question 76

A(n) ____________________ is a form that includes tabs to display forms and reports.

Question 77

Many macro actions require additional information, called the parameters of the action.

Question 78

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

Question 79

The Anchoring button allows you to tie santrols to a section or to other santrols so that they maintain the same distance between the santrol and the anchor position as the form is resized.

Question 80

Access arranges available macro actions in categories. To see the actions in a category, tap or click the expand indicator (the open triangle) in front of the category.