Deck 12: Automating Database Processes

Question 1

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

Answer 1

False

Question 2

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

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

Answer 2

D

Question 3

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

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

Answer 3

C

Question 4

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

Question 5

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

Question 6

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

Question 7

The main navigation form is created first .

Question 8

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

Question 9

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

Question 10

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

Question 11

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

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

Question 12

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

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

Question 13

A splash screen appears when you open a control.

Question 14

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

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

Question 15

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

Question 16

Access performs startup options when the splash screen is opened.

Question 17

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

Question 18

You manually create the subform controls in a Navigation form.

Question 19

Once set, Current Database options cannot be bypassed.

Question 20

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

Question 21

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

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

Question 22

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

Question 23

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.

A) Startup
B) Opening
C) Initialize
D) Database

Question 24

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

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

Question 25

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

A) buttons
B) tabs
C) symbols
D) icons

Question 26

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.

A) AutoRun
B) AutoExec
C) AutoMacro
D) Auto

Question 27

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.

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

Question 28

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

A) refreshed
B) updated
C) stopped
D) closed

Question 29

The main navigation form is the ____ form.

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

Question 30

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

A) AutoRun
B) AutoExec
C) AutoMacro
D) Auto

Question 31

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

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 32

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.

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

Question 33

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

A) buttons
B) fields
C) tabs
D) icons

Question 34

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

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

Question 35

Which statement is true of hierarchal forms?

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 36

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.

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

Question 37

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

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

Question 38

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

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

Question 39

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

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

Question 40

When a form is selected, the tab appears ____.

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

Question 42

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

Question 43

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

Question 44

The main menu appears when the splash screen ____________________.

Question 45

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

Question 46

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