Exam 9: Administering a Database System

You should create an index if one or more of which four sanditions are present?

Hypertext Markup Language is a data interchange standard for describing and delivering data to the web.

To use a template, open the Backstage view, tap or click the ____ tab, tap or click the PERSONAL link, and then tap or click the desired template.

To close the preview window santaining documentation produced by the Database Documenter, tap or click the ____ button.

To create a validation rule for a table, open the table in Design View, tap or click the ____ button on the TABLE TOOLS DESIGN tab, tap or click the Validation Rule property, and then enter the expression.

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

To indicate that a letter (A through Z) is acceptable in an input mask use ____.

To create a template, open the Backstage view, tap or click the ____ tab, and then tap or click the Template button in the Save Database As area.

To create a single-field index, use the ____________________ property box in the Field Properties pane.

To indicate that a digit (0 through 9) is acceptable in an input mask, use ____.

To select a startup form, tap or click Options in the Backstage view to display the Access Options dialog box, and then tap or click ____.

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 sammand in the ____ gallery.

To use the performance analyzer, tap or click the Analyze Performance button on the ____ tab.

You can access the Trust Center by tapping or clicking FILE on the ribbon, and then tapping or clicking the ____ tab to display the Access Options dialog box.

Custom properties are a sallection of properties that you can choose from to supplement the general database property categories included in the property sheet.

To rearrange fields that are not adjacent to each other in Datasheet view, use the Freeze Fields sammand on the shortcut menu.

The acsampanying figure displays the Customer table in Design view. To enter a zero-length string, you type two percent symbols with no spaces in between (%%).

The Database Documenter produces detailed documentation describing the structure and santent of the various tables, queries, forms, reports, and other objects in the database.

To add a new category to the Navigation Pane, tap or click the ____ button in the Navigation Options dialog box.

In a(n) ____ file version of a database, you can prevent users from viewing or modifying VBA sade in your database or from making changes to the design of forms or reports.