Exam 11: Creating and Running Macros

As you create a command button in an existing form with form operations, Access will add an event that is applicable to the object.

(True/False)

4.9/5

(26)

Question 41

A(n) embedded query can be part of another object, such as a command button.

(True/False)

4.7/5

(30)

Question 42

When you run a macro, Access performs the actions listed in the Macro window in alphabetical order.

(True/False)

4.9/5

(39)

Question 43

Case AC 11-1 The Accounting department manually runs queries every Monday morning to verify the reconciliation of salesperson salary. They have asked the Information Technology (IT) department for some assistance in saving time with this repetitive task. Because the report involves salary and private personnel information, security is an utmost priority. As the senior IT database analyst, you volunteer to help out with this request. The account manager insists that no changes should be made to the report query form when it is opened. You assure her that this can be accomplished by ____.

(Multiple Choice)

4.9/5

(29)

Question 44

A(n) ____________________ is a computer program that is designed to reproduce itself by attaching to other programs in a computer.

(Short Answer)

4.8/5

(43)

Question 45

The Before Update form event is triggered when the user begins to delete a record, but before the record is deleted.

(True/False)

4.9/5

(39)

Question 46

Showing 41 - 46 of 46

Exam 11: Creating and Running Macros

As you create a command button in an existing form with form operations, Access will add an event that is applicable to the object.

A(n) embedded query can be part of another object, such as a command button.

When you run a macro, Access performs the actions listed in the Macro window in alphabetical order.

A(n) ____________________ is a computer program that is designed to reproduce itself by attaching to other programs in a computer.

The Before Update form event is triggered when the user begins to delete a record, but before the record is deleted.

Microsoft Access Basics

Creating a Database

Creating Queries

Creating and Modifying Forms

Creating and Modifying Reports

Integrating Access

Enhancing Table Design

Using Advanced Queries

Using Advanced Form Features

Adding Advanced Features to Reports

Automating Database Processes

Programming in Access

Creating Database Security and Documentation

Microsoft Excel Basics

Using Advanced Chart Features

Improving Data Accuracy

Creating Pivottables and Pivotcharts

Using Powerful Excel Functions

Creating and Using Macros

Working With Auditing and Analysis Tools

Protecting, Tracking, and Sharing Workbooks

Importing and Exporting Data

Changing the Appearance of a Worksheet

Organizing the Worksheet

Entering Worksheet Formulas

Using Functions

Enhancing a Worksheet

Working With Multiple Worksheets and Workbooks

Working With Charts

Applying Advanced Formats to Worksheets

Microsoft Office 2010 and the Internet

Microsoft Powerpoint Basics

Sharing and Delivering Presentations

Creating Enhancing Powerpoint Presentations

Working With Visual Elements

Expanding on Powerpoint Basics

Editing and Formatting Slide Content

Working With Tables and Charts

Working With Visual and Sound Objects

Customizing Slides

Importing and Exporting Information

Microsoft Word Basics

Working With Templates and Styles

Customizing Tables and Creating Charts

Creating Mail Merge Documents

Sharing Documents

Working With Long Documents

Creating Indexes and Tables of Contents, Figures, and Authorities

Working With Long Documents

Creating Indexes and Tables of Contents, Figures, and Authorities

Basic Editing

Helpful Word Features

Formatting Text

Formatting Paragraphs and Documents

Working With Graphics

Working With Documents

Increasing Efficiency Using Word

Enhancing Documents

Filters