Question 1

You typically use data macros to ensure data security .

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

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

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

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

Question 5

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

Accepted Answer

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

Question 6

You can include ____ on a navigation santrol.

Accepted Answer

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

Question 7

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

Accepted Answer

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

Question 8

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

Accepted Answer

The answer of Many macro actions require additional information, called...

Question 9

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

Accepted Answer

The answer of In ____________________ mode, users can view data...

Question 10

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

Accepted Answer

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

Question 11

The acsampanying figure displays the Report Options group with six option buttons. To attach a macro to the option group, you first must display a property sheet for the group and tap or click the ____________________ property for the option group.

Accepted Answer

The answer of   The acsampanying figure displays the...

Question 12

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

Accepted Answer

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

Question 13

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

Accepted Answer

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

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

To make a sarrection to a macro that santains an error, tap or click the ____________________ button in the Macro Single Step dialog box and then modify the design of the macro.

Accepted Answer

The answer of To make a sarrection to a macro...

Question 16

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

Accepted Answer

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

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

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.

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

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.

Accepted Answer

A) True 
 B)False

Exam 8: Macros, Navigation Forms, and Control Layouts

You typically use data macros to ensure data security .

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

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

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

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

You can include ____ on a navigation santrol.

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

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

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

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

The acsampanying figure displays the Report Options group with six option buttons. To attach a macro to the option group, you first must display a property sheet for the group and tap or click the ____________________ property for the option group.

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

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

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

To make a sarrection to a macro that santains an error, tap or click the ____________________ button in the Macro Single Step dialog box and then modify the design of the macro.

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

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

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.

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

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.

Databases and Database Objects

Querying a Database

Maintaining a Database

Creating Reports and Forms Question

Multiple-Table Forms Question MC

Advanced Report Techniques Question

Advanced Form Techniques

Administering a Database System

Using Sql Question

Database Design

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting Question

Working With Large Worksheets, Charting, and What-If Analysis Question

Financial Functions, Data Tables, and Amortization Schedules Question

Working With Multiple Worksheets and Workbooks Question

Creating, Sorting, and Querying a Table Question

Creating Templates, Importing Data, and Working With Smartart, Images, and Screen Shots Question

Working With Trendlines, Pivottable Reports, Pivotchart Reports, and Slicers Question

Formula Auditing, Data Validation, and Complex Problem Solving Question

Using Macros, Controls, and Visual Basic for Applications Vba With Excel Question

Collaboration Features for Workbooks Question

Appendix: Introduction to Technology

Appendix: Office 365 Essentials

Managing Email Messages With Outlook

Managing Calendars With Outlook

Managing Contacts and Personal Contact Information With Outlook

Creating and Managing Tasks With Outlook

Customizing Outlook

Creating and Editing a Presentation With Pictures

Enhancing a Presentation With Pictures, Shapes, and Wordart

Reusing a Presentation and Adding Media and Animation

Creating and Formatting Information Graphics

Collaborating on and Delivering a Presentation

Navigating Presentations Using Hyperlinks and Action Buttons

Creating a Self-Running Presentation Containing Animation

Customizing a Template and Handouts Using Masters

Modifying a Presentation Using Graphical Elements

Developing a Presentation With Content From Outside Sources

Organizing Slides and Creating a Photo Album

Creating, Formatting, and Editing in Webct

Creating a Research Paper With References and Sources

Creating a Business Letter With a Letterhead and Table

Creating a Document With a Title Page, Lists, Tables, and a Watermark

Using a Template to Create a Resume and Sharing a Finished Document

Generating Form Letters, Mailing Labels, and a Directory

Creating a Newsletter With a Pull-Quote and Graphics

Using Document Collaboration, Integration, and Charting Tools

Creating a Reference Document With a Table of Contents and an Index

Creating a Template for an Online Form

Enhancing an Online Form and Using Macros

Filters