Exam 11: Administering a Database Syste

To indicate how records are to be locked when multiple users are using a database at the same time, open the Backstage view, click Options, and then click _____ in the Access Options dialog box.

To ensure that data is entered in the field and that a zero-length string is not appropriate, you can set the _____ property to Yes and the Allow Zero Length property to No.

A(n) ____________________ is a file that contains the elements needed to produce a specific type of complete database.

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

To convert an Access 2000 or Access 2002-2003 database to the default file format for Access 2010, you open the database in Access 2010.

When you populate a property, you set a value for the property.

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

You cannot print the documentation produced by the Database Documenter but you can create a PDF file, an XPS file, or a Word file.

Modified Multiple Choice Administering a database includes activities to improve the _____ of the database.

The accompanying figure displays the Client table in Design view. If you enter the & symbol at the beginning of an input mask, it ensures that any characters entered are converted to uppercase.

The Trust Center is a feature within Access where you can set security options and also find the latest information on technology related to privacy, safety, and security.

Which two issues should you consider when determining whether the database should be split?

To create a blank Web database, open the Backstage view, click the New tab, and then click the _____ button.

Modified Multiple Choice To indicate that a letter (A through Z) is acceptable in an input mask use _____.

To ensure that values in a field are required, click the _____ check box on the Table Tools Fields tab.

To add a group to a category, click the _____ button in the Navigation Options dialog box.

The accompanying figure displays the Client table in Design view. If the same field has both an input mask and a format, the input mask takes precedence.

The Performance Analyzer will examine the database's tables, queries, reports, forms, and other objects in your system, looking for changes that would improve the efficiency of database operations.