Exam 11: Administering a Database Syste

If a database contains features that are specific to Access 2007 or Access 2010, you cannot convert it to an earlier version.

To delete a category, click the _____ button in the Navigation Options dialog box.

Critical Thinking Questions Case 10-1 An employee at Camashaly Design needs to create an input mask for the five-digit postal code in the Client table. The employee also wants to ensure that data is entered in the Services Needed field but there may be times when an entry in the Services Needed field is not appropriate. What should be entered in the Input Mask property box to ensure that five digits are entered in the Postal Code field?

The accompanying figure displays the Clients and Trainers database on the Web. A Web database is a database that is designed to be published to the Web on a SharePoint server.

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

The accompanying figure displays the Trust Center in the Access Options dialog box. The ___________________ option in the Trust Center dialog box allows you to choose whether the message bar should appear when content has been blocked.

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

Redundancy is duplicated data.

One way to prevent users from entering data that does not have a certain format is to use a(n) ____________________.

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

Modified Multiple Choice You can open a database in _____ mode.

When you split a database, the ____________________ database contains all the queries, reports, forms, and so on from the original database.

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

To create a custom category on the Navigation Pane, right-click the Navigation Pane and click the _____ command on the shortcut menu.

To use the Performance Analyzer, click the Analyze Performance button on the _____ tab.

The More button in the Documenter dialog box allows you to further specify what to include for each table and for each field in a table.

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

When you package and sign an Access database, Access will save the result in the ____________________ file format (.accdc).

Critical Thinking Questions Case 10-2 Camashaly Design has two different groups of users. One user group wants to be able to tailor forms and reports to their individual needs. The other user group should be able to use the database but should not be able to make changes to the design of forms or reports. What should management do to prevent users from making changes to the design of forms or reports?