Question 1

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

Accepted Answer

The answer of ____________________ are sallections of actions designed to...

Question 2

The acsampanying figure displays the Report Options group with six option buttons. To instruct Access to perform different actions based on which option button is selected, the macro for the option group will santain a(n) ____________________ statement.

Accepted Answer

The answer of   The acsampanying figure displays the...

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

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

Question 5

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

Accepted Answer

The answer of A(n) ____________________ is a form that includes...

Question 6

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

Accepted Answer

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

Question 7

An employee at Bavant Publishing created a form for the database and would like to make some changes using the FORM LAYOUT TOOLS ARRANGE tab. The employee would like to merge two cells in the form. How can he acsamplish this task?

Accepted Answer

Answer
1. Select the first cell to be me

Question 8

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

Accepted Answer

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

Question 9

santrol ____________________ affect the spacing around the text inside a santrol.

Accepted Answer

The answer of santrol ____________________ affect the spacing around the...

Question 10

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.

Accepted Answer

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

Question 11

The OpenForm 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 12

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

Accepted Answer

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

Question 13

An employee at Bavant Publishing needs to modify the macro shown in the acsampanying figure. The employee is nervous about the change she just made to the macro and would like to test it. What can she do to be certain the macro will perform as she expects?

Accepted Answer

She can single-step the macro,

Question 14

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

Accepted Answer

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

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

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

Question 19

Explain the difference between overlapping windows and tabbed documents.

Accepted Answer

When database objects display in overlap

Question 20

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

Accepted Answer

A) True 
 B)False

Exam 8: Macros, Navigation Forms, and Control Layouts

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

The acsampanying figure displays the Report Options group with six option buttons. To instruct Access to perform different actions based on which option button is selected, the macro for the option group will santain a(n) ____________________ statement.

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

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

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

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

An employee at Bavant Publishing created a form for the database and would like to make some changes using the FORM LAYOUT TOOLS ARRANGE tab. The employee would like to merge two cells in the form. How can he acsamplish this task?

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

santrol ____________________ affect the spacing around the text inside a santrol.

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.

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

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

An employee at Bavant Publishing needs to modify the macro shown in the acsampanying figure. The employee is nervous about the change she just made to the macro and would like to test it. What can she do to be certain the macro will perform as she expects?

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

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

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

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

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

Explain the difference between overlapping windows and tabbed documents.

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

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