Exam 12: Automating Database Processes

When creating an AutoExec macro, it must be saved using the name ____.

(Multiple Choice)

4.7/5

(34)

Question 41

FIGURE AC 12-6 In Figure AC 12-6 above, ____ show how the tabs will be arranged.

(Multiple Choice)

4.9/5

(38)

Question 42

AC Case 12-1 Taylor needs to display a splash screen when users open an inventory database. She knows VBA has a macro to help with this task; however, Taylor is unsure of how to use the macro. Taylor asks for your assistance. You suggest that Taylor use the _____ macro.

(Multiple Choice)

4.8/5

(31)

Question 43

When revising current database options, a message box appears stating that the current database needs to be ____ before the options can take effect.

(Multiple Choice)

4.8/5

(38)

Question 44

AC Case 12-2 Jennifer has designed a new Salary database. She would like to hide the Navigation pane and the Ribbon. Jennifer also wants to make sure that only authorized users, such as the database manager, can work with tables and other objects in Design view. She asks for your assistance. You suggest Jennifer add ____ options.

(Multiple Choice)

4.7/5

(35)

Question 45

Selecting the ____ on a main menu navigation form lets you instantly view the objects.

(Multiple Choice)

4.8/5

(33)

Question 46

Showing 41 - 46 of 46

Exam 12: Automating Database Processes

When creating an AutoExec macro, it must be saved using the name ____.

FIGURE AC 12-6 In Figure AC 12-6 above, ____ show how the tabs will be arranged.

AC Case 12-1 Taylor needs to display a splash screen when users open an inventory database. She knows VBA has a macro to help with this task; however, Taylor is unsure of how to use the macro. Taylor asks for your assistance. You suggest that Taylor use the _____ macro.

When revising current database options, a message box appears stating that the current database needs to be ____ before the options can take effect.

Selecting the ____ on a main menu navigation form lets you instantly view the objects.

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

Creating and Running Macros

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