Exam 5: Maintaining a Database

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

To create a multivalued field, create a(n) ____________________ field being sure to check the Allow Multiple Values check box.

To specify that entries in the Returns field must be between $0.00 and $30,000.00, enter ____ in the Validation Rule property box.

A(n) ____________________ is a form that allows you to simultaneously view both simple form and datasheet views of the data.

To add the Book Rep and Customer tables to the Relationships window shown in the accompanying figure, tap or click the Add button in the ___________________ dialog box.

To move to the first record using the form shown in the accompanying figure, tap or click the ____ button on the Navigation bar.

When specifying referential integrity, one way to handle the update of a primary key is to _________________________; that is, have Access allow the update but then automatically make the corresponding change in any related records in other tables.

To display the Total row in a datasheet, tap or click the Sum button on the ribbon.

Critical Thinking Questions Case 3-2 Bavant has just realized that they need to make some additional changes to the Customer table shown in Design view in the accompanying figure. They have asked you to make these changes. Because Bavant may move the database to SQL Server, they have decided to delete the Resources Needed field. How do you delete the field?

A ___ field allows the user to select from a list of values.

To use Filter By Form to filter records, tap or click the ____ button on the HOME tab and then click Filter By Form.

Critical Thinking Questions Case 3-1 Bavant Publishing has decided to add some additional validation rules to the Customer table shown in Design view in the accompanying figure. They have asked you to create these validation rules. Because many of the customers that Bavant Publishing services are located in Pennsylvania, management would like to minimize any data entry in this field. What property do you need to change and what would you enter in the property box?

To save validation rules, default values, and formats, tap or click the Save button on the ____ to save the changes.

When specifying referential integrity, one way to handle deletions is to _________________________; that is, have Access allow the deletion but then automatically delete any related records in other tables.

You can convert a Number field to a Currency field but you cannot convert a Currency field to a Number field.

Modified Multiple Choice Validation rules can indicate a ____.

To create a split form, select the table in the Navigation Pane, tap or click CREATE on the ribbon, tap or click the ____ button on the CREATE tab to display a menu, and then tap or click Split Form on the menu.

You cannot preview the data to be updated in an update query before actually performing the update.