Exam 16: Administering the Database

If you split an Access database, what is the name of the database that is stored on the file server?

Use a(n) ____ to maintain constant power to a file server in the event of a power problem.

Set the Initial Form startup option to specify which form opens when the database application opens.

____ passwords are longer than eight characters and use the entire keyboard, including uppercase and lowercase letters, numbers, and symbols.

In Access 2013, the default file extension for a relational database is _____

Closing all applications that you don't currently need to free up memory is a relatively easy way to improve performance.

Command-line options follow which character in the path to the file?

External hard drives typically have more storage capacity than USB drives.

Identify three benefits of the Access 2007 database file format over its predecessors.

This startup command-line option repairs the database.

Match the Access options dialog box category with the best choice. -Determines the default gridlines, cell effects, and fonts

-The dialog box in the figure is accessed from which tab on the Ribbon?

Which Access database file format supports the Attachment data type?

Match the Access options dialog box category with the best choice. -Sets default interface, file format, default database folder, and user name options

This startup command-line option starts Access and runs the specified macro.

A(n) ____ can cause a vast number of damaging actions ranging from profane messages to destruction of files.

3.5-inch disks with roughly 1 MB of storage capacity are a common portable storage device today.

A(n) _____ form is a special Access form that provides an easy-to-use database interface that is also Web compatible.

One of the reasons to split a database is to improve performance.

-The form in the figure displays the frmEmployees form on the first tab.