FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 5: Access: Maintaining a Database

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 1

Matching

Review LaterAdd Note

Review Later

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

Premises

Responses

Allows you to make the same change to all records.

default value

required field

delete query

<

validation text

update query

make-table query

validation rules

append query

(?)

Premises

Allows you to make the same change to all records.

Responses

default value

required field

delete query

<

validation text

update query

make-table query

validation rules

append query

(?)

Show Answer

Correct Answer

Premises

Responses

default value

required field

delete query

<

validation text

update query

make-table query

validation rules

append query

(?)

Premises

default value

required field

delete query

<

validation text

update query

make-table query

validation rules

append query

(?)

Responses

Question 2

Essay

Review LaterAdd Note

Review Later

Critical Thinking Questions Case 2 JSP Recruiters has just realized that they need to make some additional changes to the Client table shown in Design view in the accompanying figure. They have asked you to make these changes. Figure 3-4. JSP would like to add a telephone number field to the Client table. The field should appear after the postal code field. What do you need to do to add the field?

Correct Answer

verified

To add the field click the row selector ...

View Answer

Show Answer

Question 3

Multiple Choice

Review LaterAdd Note

Figure 3-2 To delete record EA45 shown in the accompanying figure, click the record selector in the datasheet for the record on which the client number is EA45 and then press ____.

Normally, Access prohibits the deletion of a record in which the primary key matches a foreign key in another table.

The command on the shortcut menu that displays data in Form view is Form View.

The simplest type of filter is called 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 preview data to be deleted in a delete query, click the ____ button after you create the query, but before you run it.

If the TAB key is used to move from field to field in a record, press F2 to produce an insertion point in a field.

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.

To quit Access, click the ____ button on the right side of the Access title bar.

To create a simple form, select the table in the Navigation Pane, click Create on the Ribbon and then click the ____ button on the Create tab.

Six guidelines are available for you to use when determining database maintenance tasks. What are these six guidelines?

To create a Lookup field, select ____________________ from the menu of available data types.

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

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

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

Critical Thinking Questions Case 1 JSP Recruiters 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. Figure 3-4 JSP would like to make sure that if an employee enters the letters co in the State field that it displays in the database as CO. What property do you need to change and what would you enter in the property box?

Changing a column width changes the format , or design, of a table.