Question 1

A(n) ____________________ is a special kind of form that has both a main form control and subform controls automatically built in.

Accepted Answer

navigation form

Question 2

When dragging the header bar, the mouse pointer appears as a(n) ____.

Accepted Answer

A)  crosshair 
B)  ellipse 
C)  lightening bolt 
D)  double-headed arrow 
A)  crosshair 
B)  ellipse 
C)  lightening bolt 
D)  double-headed arrow D

Question 3

A navigation form acts as a map for the splash screen.

Accepted Answer

A) True 
 B)False  False

Question 4

The use of navigation forms in a database is similar to navigating a Web site.

Accepted Answer

A) True 
 B)False

Question 5

Navigation forms in a database typically appear in a linear format.

Accepted Answer

A) True 
 B)False

Question 6

A splash screen appears when you open a control.

Accepted Answer

A) True 
 B)False

Question 7

At least ____ lower-level form(s) need to be placed on an upper-level navigation form.

Accepted Answer

A)  one 
B)  two 
C)  three 
D)  four 
A)  one 
B)  two 
C)  three 
D)  four

Question 8

FIGURE AC 12-6   As referenced in Figure AC 12-6 above, before designing a navigation form, you should decide on the type of ____ you want to use.

Accepted Answer

A)  database layout 
B)  layout style 
C)  navigation direction 
D)  button layout 
A)  database layout 
B)  layout style 
C)  navigation direction 
D)  button layout

Question 9

To add background color to a splash screen, you click the ____ tab on the Design tab ribbon.

Accepted Answer

A)  Fill 
B)  Background 
C)  Color 
D)  Format 
A)  Fill 
B)  Background 
C)  Color 
D)  Format

Question 10

To open a database without the specified startup options, you press and hold the ____.

Accepted Answer

A)  DEL key 
B)  SHIFT key 
C)  CTRL + SHIFT keys 
D)  CTRL + DEL keys 
A)  DEL key 
B)  SHIFT key 
C)  CTRL + SHIFT keys 
D)  CTRL + DEL keys

Question 11

Whenever a user opens a database, the splash screen looks for an AutoExec macro.

Accepted Answer

A) True 
 B)False

Question 12

Forms in the lower level of the hierarchy are produced first.

Accepted Answer

A) True 
 B)False

Question 13

You deselect the Allow Full Menus feature so that ____ not displayed.

Accepted Answer

A)  most of the Ribbon is 
B)  all of the Ribbon is 
C)  most of the forms are 
D)  all of the forms are 
A)  most of the Ribbon is 
B)  all of the Ribbon is 
C)  most of the forms are 
D)  all of the forms are

Question 14

When a form is selected, the tab appears ____.

Accepted Answer

A)  in yellow 
B)  with a dark line surrounding it 
C)  in a darker color 
D)  in a lighter color 
A)  in yellow 
B)  with a dark line surrounding it 
C)  in a darker color 
D)  in a lighter color

Question 15

A ____ that welcomes the user to the database is known as a splash screen.

Accepted Answer

A)  window 
B)  form 
C)  box 
D)  menu 
A)  window 
B)  form 
C)  box 
D)  menu

Question 16

To add an object to the navigation form, you drag the object directly from the Navigation pane onto the form.

Accepted Answer

A) True 
 B)False

Question 17

After you create a database, to run the AutoExec macro, you need to close the database and then reopen the database.

Accepted Answer

A) True 
 B)False

Question 18

The main navigation form serves as the main menu, letting you select the ____ navigation forms in the main form.

Accepted Answer

A)  lower-level 
B)  upper-level 
C)  startup 
D)  control 
A)  lower-level 
B)  upper-level 
C)  startup 
D)  control

Question 19

When opening a database, an available AutoExec macro runs before any other tasks are performed.

Accepted Answer

A) True 
 B)False

Question 20

The main navigation form is the ____ form.

Accepted Answer

A)  lead-in 
B)  upper-level 
C)  startup 
D)  control 
A)  lead-in 
B)  upper-level 
C)  startup 
D)  control

Exam 12: Automating Database Processes

A(n) ____________________ is a special kind of form that has both a main form control and subform controls automatically built in.

When dragging the header bar, the mouse pointer appears as a(n) ____.

A navigation form acts as a map for the splash screen.

The use of navigation forms in a database is similar to navigating a Web site.

Navigation forms in a database typically appear in a linear format.

A splash screen appears when you open a control.

At least ____ lower-level form(s) need to be placed on an upper-level navigation form.

FIGURE AC 12-6 As referenced in Figure AC 12-6 above, before designing a navigation form, you should decide on the type of ____ you want to use.

To add background color to a splash screen, you click the ____ tab on the Design tab ribbon.

To open a database without the specified startup options, you press and hold the ____.

Whenever a user opens a database, the splash screen looks for an AutoExec macro.

Forms in the lower level of the hierarchy are produced first.

You deselect the Allow Full Menus feature so that ____ not displayed.

When a form is selected, the tab appears ____.

A ____ that welcomes the user to the database is known as a splash screen.

To add an object to the navigation form, you drag the object directly from the Navigation pane onto the form.

After you create a database, to run the AutoExec macro, you need to close the database and then reopen the database.

The main navigation form serves as the main menu, letting you select the ____ navigation forms in the main form.

When opening a database, an available AutoExec macro runs before any other tasks are performed.

The main navigation form is the ____ form.

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