Exam 11: Administering a Database Syste

When a database is opened in compatibility mode, all features are enabled.

You can assign properties to tables.

___________________ is a data interchange standard for describing and delivering data on the Web.

You can create a PDF or XPS file containing the documentation produced by the Database Documenter.

To ensure that automatic error checking is enabled, click _____ to display the options for creating and modifying objects in the Access Options dialog box.

If automatic error checking is enabled and an error occurs, a small triangle called a(n) _____ appears in the appropriate field or control.

To close the preview window containing documentation produced by the Database Documenter, click the _____ button.

____________________ means duplicating data.

To create data parts in the Quick Start category from existing fields, select the desired field or fields and then select the Save Selection As New Data Type command in the _____ gallery.

To create a multiple-field index, click the _____ button on the Design tab.

To create a new query, display the Create tab and then click the _____ button in the Queries group.

____________________ refers to the storing of data in the database in an encoded format.

The accompanying figure shows the Set Database Password dialog box. To encrypt a database with a password, click the _____ button on the Info tab in Backstage view.

The Redundancy Analyzer can analyze tables while looking for potential redundancy.

____________________ make the process of retrieving records very fast and efficient.

When you add an item to a group on the Navigation Pane, you really create a link to the object.

The accompanying figure displays the Clients and Trainers database on the Web. When you create a Web database, you must create the tables in Design view.