Exam 14: Creating Database Security and Documentation

You click the ____________________ tab and if necessary the Info tab, to access the Encrypt with Password option.

In Access, the Object Documenter produces a report of selected objects or every object in a database.

When saving a backup database file, the date is added after the filename.

Case AC 14-2 Ted recently finished creating a supplier database. The internal auditors are currently reviewing Ted's project and would like to see the properties of all the objects as well as their relationships. To satisfy the auditor's request, Ted should use the ____ tool.

Selecting the Back Up Database option alerts Access that when you click ____, you want to create a backup of the database.

____ mode allows several users to open and use the database at the same time.

If you click the File tab and notice that the Encrypt with Password option is ____, this indicates that the password and encryption are removed.

To remove database encryption, you must enter the password in the ____ Database Password dialog box.

In the Database Tools tab ____________________ group, click the Database Documenter button to open the Documenter dialog box.

To remove the password and encryption from a database, you first need to open the database in the Open Read-Only mode.

Which of the following events may cause data loss requiring a database restore from a backup?

The message " Block cipher is incompatible with row level locking and so row level locking will be ignored" ensures that ____ will be encrypted.

FIGURE AC 14-11 In Figure 14-11 above, click the ____ tab to see all of the objects in the database.

If a password is needed to open a database, the ____ dialog box appears.

Which of the following causes a message similar to " Block cipher is incompatible with row level locking and so row level locking will be ignored" ?

Case AC 14-1 Ron wants to convert his paper-based customer information system to an Access 2010 database stored on his laptop. However, Ron is concerned about placing the information on his laptop because he also uses the laptop for Internet access. He asks for your advice. To ease Ron's concerns, you start by explaining that Access 2010 combines two tools for database security: ____.

Describe the various security and documentation features Microsoft Access offers to protect a database from losing important information.

Using the ____ mode allows multiple users to open a database, but they cannot add or change records and they cannot create new objects.

You can add a password to a database, which encrypts, or ____________________, the data.

A backup copy of a database is created when you ____ the file using the Back Up Database option.