Question 1

You manually create the subform controls in a Navigation form.

Accepted Answer

A) True 
 B)False

Question 2

In previous versions of Access, you might have used a ____ for the purpose of creating menus in a hierarchical format.

Accepted Answer

A)  Switch 
B)  Switchboard 
C)  map 
D)  main menu 
A)  Switch 
B)  Switchboard 
C)  map 
D)  main menu

Question 3

A(n) ____________________ allows you to have one or more actions automatically execute when the database is opened.

Accepted Answer

The answer of A(n) ____________________ allows you to have one...

Question 4

To prevent users from changing or modifying the design of your database, you can ____.

Accepted Answer

A)  define locks on the ribbon 
B)  define locks on the user 
C)  restrict the Ribbon pane 
D)  restrict the Ribbon tabs 
A)  define locks on the ribbon 
B)  define locks on the user 
C)  restrict the Ribbon pane 
D)  restrict the Ribbon tabs

Question 5

Access performs startup options when the splash screen is opened.

Accepted Answer

A) True 
 B)False

Question 6

You use ____ forms to design and implement user-friendly menus so that users can work with only those parts of the database they need.

Accepted Answer

A)  splash screen 
B)  startup 
C)  navigation 
D)  macro 
A)  splash screen 
B)  startup 
C)  navigation 
D)  macro

Question 7

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 explain that these options are located in the ____ dialog box.

Accepted Answer

A)  Startup 
B)  Macro 
C)  Access Options 
D)  Startup Options 
A)  Startup 
B)  Macro 
C)  Access Options 
D)  Startup Options

Question 8

Navigation forms in the lower level of the hierarchy are produced ____.

Accepted Answer

A)  first 
B)  second 
C)  randomly 
D)  last 
A)  first 
B)  second 
C)  randomly 
D)  last

Question 9

The main navigation form is created first .

Accepted Answer

A) True 
 B)False

Question 10

Explain why you should use the same style throughout the database.

Accepted Answer

Once you decide on the navigation form l

Question 11

A(n) ____________________ welcomes the user to the database.

Accepted Answer

The answer of A(n) ____________________ welcomes the user to the...

Question 12

To add a label to a splash screen, you use the ____ view within the Design tab.

Accepted Answer

A)  Layout 
B)  Design 
C)  Form 
D)  Datasheet 
A)  Layout 
B)  Design 
C)  Form 
D)  Datasheet

Question 13

The main menu appears when the splash screen ____________________.

Accepted Answer

The answer of The main menu appears when the splash...

Question 14

Within a navigational form, a Forms Menu is at the higher level of the hierarchy.

Accepted Answer

A) True 
 B)False

Question 15

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. To create the macro used to display the splash screen, Taylor should use the ____ window to select the actions she wants Access to perform when the database is opened.

Accepted Answer

A)  Create 
B)  Actions 
C)  Macro 
D)  Options 
A)  Create 
B)  Actions 
C)  Macro 
D)  Options

Question 16

Once set, Current Database options cannot be bypassed.

Accepted Answer

A) True 
 B)False

Question 17

Selecting a newly added navigation form tab lets you view a report in the subform control.

Accepted Answer

A) True 
 B)False

Question 18

Which statement is true of hierarchal forms?

Accepted Answer

A)  They make database maintenance more difficult. 
B)  They make database security more difficult. 
C)  They help users select various database objects easily. 
D)  They help programmers select various database controls easily. 
A)  They make database maintenance more difficult. 
B)  They make database security more difficult. 
C)  They help users select various database objects easily. 
D)  They help programmers select various database controls easily.

Question 19

Match between columns
                        Premises: Lets you select which report you want to view.
Has tabs that let you select the lower-level forms.
Refers to the different levels of automation.
You can only have one of these per database file.
Used to personalize a splash screen.

Accepted Answer

The Answer of lower-level navigation form and hierarchical and AutoExec is...

Question 20

When creating an AutoExec macro, you add the ____________________ action so you can open a form when the macro runs.

Accepted Answer

The answer of When creating an AutoExec macro, you add...

Exam 12: Automating Database Processes

You manually create the subform controls in a Navigation form.

In previous versions of Access, you might have used a ____ for the purpose of creating menus in a hierarchical format.

A(n) ____________________ allows you to have one or more actions automatically execute when the database is opened.

To prevent users from changing or modifying the design of your database, you can ____.

Access performs startup options when the splash screen is opened.

You use ____ forms to design and implement user-friendly menus so that users can work with only those parts of the database they need.

Navigation forms in the lower level of the hierarchy are produced ____.

The main navigation form is created first .

Explain why you should use the same style throughout the database.

A(n) ____________________ welcomes the user to the database.

To add a label to a splash screen, you use the ____ view within the Design tab.

The main menu appears when the splash screen ____________________.

Within a navigational form, a Forms Menu is at the higher level of the hierarchy.

Once set, Current Database options cannot be bypassed.

Selecting a newly added navigation form tab lets you view a report in the subform control.

Which statement is true of hierarchal forms?

When creating an AutoExec macro, you add the ____________________ action so you can open a form when the macro runs.

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