FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 5: Maintaining a Database

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 51

Short Answer

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 52

Multiple Choice

Review LaterAdd Note

Review Later

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) >=0, <=30,000
B) >=$0, <=$30,000
C) >=0 and <=30000
D) >=$0 and <=$30,000

E) B) and D)
F) All of the above

Correct Answer

verified

Show Answer

Question 53

Multiple Choice

Review LaterAdd Note

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 can convert a Number field to a Currency field but you cannot convert a Currency field to a Number field.

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

Identify the letter of the choice that best matches the phrase or definition.

Identify the letter of the choice that best matches the phrase or definition.

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

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.

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

Modified Multiple Choice Validation rules can indicate a ____.

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?

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.

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

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

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

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.

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.