Exam 11: Administering a Database Syste

When you split a database, the ____________________ database contains the actual tables, but does not contain any other objects.

To lock a database, open the Backstage view, click the Save and Publish tab, and then click _____ in the Advanced area.

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

You cannot use the expression builder to create a validation rule.

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

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

To create a single-item form, display the Create tab and then click the _____ button in the Forms group.

The accompanying figure displays the Client table in Design view. The Format property ensures that data is displayed consistently, for example, always in uppercase.

Both Access 2007 and Access 2010 use the _____ file format.

You can access the Trust Center by clicking File on the Ribbon, and then clicking the _____ button to display the Access Options dialog box.

When the same field has both an input mask and a format, the ____________________ takes precedence.

The Format property controls how data is entered.

To hide a field in Datasheet view, right-click the field and click _____ on the shortcut menu.

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

Modified Multiple Choice _____ parts are templates that you can add to your database to extend its functionality.

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

The data type error, Unassociated label and control, indicates that a label and control are selected that are not associated with each other.

To create a validation rule for a table, open the table in Design View, click the _____ button on the Design tab, click the Validation Rule property, and then enter the expression.