Exam 11: Administering a Database Syste

In Access, you encrypt a database and set a password as separate operations.

To distinguish data that does not exist from data that is unknown, use ____________________ strings.

The \ symbol entered at the beginning of an input mask ensures that any characters entered are converted to lowercase.

What is the difference between the Format property and the Input Mask property?

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. If the Allow Zero Length property has the value Yes, what should you enter in the Services Needed field when an entry is not appropriate?

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

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 make sure that employees can make individual changes to the forms and reports?

To use an application part, display the Create tab and then click the _____ button in the Templates group.

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

The accompanying figure displays the Trust Center in the Access Options dialog box. In the Trust Center dialog box, ____________________ are additional programs that you can install and use within Access.

The accompanying figure displays the Trust Center in the Access Options dialog box. The ___________________ option in the Trust Center dialog box allows you to change the levels of macro security.

The accompanying figure displays the Client table in Design view. If the input mask for client number is LL99 the last two positions are optional.

The accompanying figure displays the Clients and Trainers database on the Web. If you plan to use forms and reports in a Web database, you must create the forms and reports in Layout view.

The accompanying figure displays the Clients and Trainers database on the Web. When you create a Web database, you must specify relationships through lookup fields.

To open a database so that you can read the data in the database but not update the data, click the Open button arrow, and then click _____ in the Open button menu that appears.

The accompanying figure displays the Trust Center in the Access Options dialog box. The ___________________ option in the Trust Center dialog box shows you the list of trusted software publishers.

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

To use the table analyzer, click the Analyze Table button on the _____ tab.