Exam 6: Access: Maintaining a Database

Maintenance of a database can involve the need to _________________________ periodically;that is,to change the database structure.

You can add a record to a table by ____.

You can search for a record in Form view but not in Datasheet view.

MATCHING Identify the letter of the choice that best matches the phrase or definition. a.append query f.validation text b.delete query g.required field c.make-table query h.default value d.update query i.calculated field e.validation rules j.< -Allows you to delete all the records satisfying some criterion.

A default value is a value that Access will display on the screen in a particular field before the user begins adding a record.____________________

To open a form in Form view from the Navigation Pane,press and hold or right-click the form and tap or click Form View on the shortcut menu.

The Unfilter button toggles between filtered and unfiltered displays of the records in a table.

MATCHING Identify the letter of the choice that best matches the phrase or definition. a.append query f.validation text b.delete query g.required field c.make-table query h.default value d.update query i.calculated field e.validation rules j.< -A field in which the user actually must enter data.

Looking for the customer whose number is PLI22 is an example of searching.

When you use a split form,you only can add records using the simple form.

To order the records in the Customer table in reverse alphabetical order by City,click the ____ button.

Validation rules ensure validity of the data in the database,while entity integrity ensures the validity of the relationships.

To remove a total row that appears in a datasheet,tap or click the ____ button on the HOME tab.

When the Book Rep table is related to the Customer table,it is possible to view the customers of a given book rep when you are viewing the datasheet for the Book Rep table.The customers for the book rep will appear below the book rep in a split form.____________________

When you have created a filter using Advanced Filter/Sort,you can save the filter settings as a query by using the ____________________ command on the Advanced menu.

When a filter is in effect,you can redisplay all records by tapping or clicking the ____ button on the HOME tab.

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.

As an alternate to using the Find button,you can press ____ to search for a specific record and display the Search and Replace dialog box shown in the accompanying figure.

To change gridlines in a datasheet,open the table in Datasheet view,select the entire datasheet,and tap or click the ____________________ button on the HOME tab.

MATCHING Identify the letter of the choice that best matches the phrase or definition. a.append query f.validation text b.delete query g.required field c.make-table query h.default value d.update query i.calculated field e.validation rules j.< -Allows you to add the results of a query to a new table.