Exam 4: Maintaining a Database

In the Camashaly Design database, a one-to-many relationship exists between the Business Analyst table and the Client table.

To print a copy of a relationship, click the _____________________ button shown on the accompanying figure.

The relationship in the accompanying figure was created by clicking the ____________________ check box in the Edit Relationships dialog box.

When you create a calculated field, users can update the field.

When you use Filter By Form to restrict records that appear, you create the filter and then click the ____ button to apply the filter.

A lookup field allows the user to select from a list of values when updating the contents of a field.

Critical Thinking Questions Case 3-1 Camashaly Design has decided to add some additional validation rules to the Client table shown in Design view in the accompanying figure. They have asked you to create these validation rules. Camashaly would like to make sure that if an employee enters the letters nc in the State field that it displays in the database as NC. What property do you need to change and what would you enter in the property box?

To filter records using complex criteria, click the ____ button on the Home tab and then click Advanced Filter/Sort on the menu that appears.

You can restore filter settings that you previously saved in a query by using the ____________________ command on the Advanced menu.

To specify that a field is to be required, change the value for the _____ property from No to Yes.

A(n) ____ query adds a group of records from one table to the end of another table.

If a Security Warning appears when you open a database, click the ____ option button.