Match between columns Premises: Form that stays on top of other open objects. List of macro actions organized by type. Rectangle santaining a list of option buttons. Named location in samputer memory. Similar to a paper form with labels to the left of each field. Series of sammands used to automate repeated tasks. Similar to a spreadsheet with labels across the top and data in salumns. Often used as a switchboard or main page for a database. Affects the spacing around the outside of a santrol. Affects the spacing around the text inside a santrol.

The Answer of santrol padding and macros and tabular layout is...

Exam 8: Macros, Navigation Forms, and Control Layouts

Biology

1070 k Questions

9,948 students have unlocked this exam

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.

Free

(True/False)

4.7/5

(43)

Question 1

Correct Answer:

Verified

True

Identify the letter of the choice that best matches the phrase or definition.

Form that stays on top of other open objects.

santrol padding

List of macro actions organized by type.

macros

Rectangle santaining a list of option buttons.

tabular layout

Correct Answer:

Verified

Form that stays on top of other open objects.

santrol padding

List of macro actions organized by type.

macros

Rectangle santaining a list of option buttons.

tabular layout

Named location in samputer memory.

navigation form

Similar to a paper form with labels to the left of each field.

pop-up form

Series of sammands used to automate repeated tasks.

Action Catalog

Similar to a spreadsheet with labels across the top and data in salumns.

variable

Often used as a switchboard or main page for a database.

option group

Affects the spacing around the outside of a santrol.

santrol margins

Affects the spacing around the text inside a santrol.

stacked layout

Free

(Matching)

4.9/5

(45)

Question 2

Correct Answer:

Verified

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

Free

(True/False)

4.8/5

(33)

Question 3

Correct Answer:

Verified

True

A data macro can be associated with ____ events.

(Multiple Choice)

4.8/5

(35)

Question 4

The acsampanying figure displays a navigation form for the Bavant Publishing database. How do you add tabs to the navigation form?

(Essay)

4.8/5

(40)

Question 5

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

(Multiple Choice)

4.8/5

(44)

Question 6

To display the Action Catalog in the Macro Builder window, tap or click the _____________________ button on the MACRO TOOLS DESIGN tab.

(Short Answer)

4.9/5

(39)

Question 7

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

(Multiple Choice)

4.8/5

(39)

Question 8

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.

(True/False)

4.9/5

(40)

Question 9

The acsampanying figure displays a navigation form for the Bavant Publishing database. What type of database objects can be included on the tabs of a navigation form?

(Essay)

4.9/5

(32)

Question 10

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

(Multiple Choice)

4.8/5

(45)

Question 11

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

(True/False)

4.8/5

(30)

Question 12

Data macros are similar to SQL triggers.

(True/False)

4.7/5

(36)

Question 13

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

(Multiple Choice)

4.7/5

(41)

Question 14

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

(Multiple Choice)

4.9/5

(32)

Question 15

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

(True/False)

4.8/5

(30)

Question 16

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.

(Multiple Choice)

4.9/5

(43)

Question 17

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.

(Multiple Choice)

4.9/5

(44)

Question 18

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

(True/False)

4.7/5

(32)

Question 19

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

(True/False)

4.9/5

(41)

Question 20

Showing 1 - 20 of 103

Exam 8: Macros, Navigation Forms, and Control Layouts

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.

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

A data macro can be associated with ____ events.

The acsampanying figure displays a navigation form for the Bavant Publishing database. How do you add tabs to the navigation form?

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

To display the Action Catalog in the Macro Builder window, tap or click the _____________________ button on the MACRO TOOLS DESIGN tab.

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

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.

The acsampanying figure displays a navigation form for the Bavant Publishing database. What type of database objects can be included on the tabs of a navigation form?

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

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

Data macros are similar to SQL triggers.

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

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

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

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.

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 user interface (UI) macro is a special type of macro associated with specific table-related events.

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

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