Exam 15: Administering the Database

Which file extension is associated with the file that coordinates the multiuser capabilities of Access 2010?

You can _____ an Access database into a back-end database and front-end database.

Which options would Wendy use in the figure shown to set the opening form and also make sure that the database was compacted and repaired every time it was closed?

The Performance Analyzer makes a variety of recommendations on how you can improve database performance.

_____ options are a series of commands that execute when the database is opened.

Access to queries, forms, and reports may all be added to a navigation form.

Which of the following is NOT a level of advice regarding performance as analyzed by the Performance Analyzer?

____ means that you are the only person who has the database open and others will not be able to open the file during this time.

Differentiate between the Save Database As and Save Object As commands on the FILE tab.

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

To add a new tab to the form shown in the figure, click the [Add New] tab.

Which Access database file format supports the Attachment data type?

In the figure above, if you save to a database template file, you will create a file with a .accde file extension.

A(n) ____ option is a special set of characters added to the end of the path name to a database which execute a command when the database file is opened.

Which of the following Access options provides a way to set security, macro, and other privacy settings?

_____ a database refers to making a copy of it in a secure location.

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

This startup command-line option opens the database for exclusive access.

You can recover a forgotten database password by opening the database in exclusive mode.

Client/server computing is defined as ____.