Exam 6: Access: Maintaining a Database

You can use a filter in either Datasheet view or Form view.

-To add a record using the form shown in the accompanying figure,tap or click the ____ button on the Navigation bar.

Maintaining a database can include ____.

A(n)____ field is a field that can be computed from other fields.

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

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

To move from Layout view to Form view,tap or click the ____ button on the Access status bar.

To indicate that the only allowable values for the Customer Type field are HS,COM,and UNI,enter ____ in the Validation Rule property box.

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

If a SECURITY WARNING appears when you open a database,tap or click the ____ option button.

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.< -Rules that a user must follow when entering data.

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 make the same change to all records.

To include totals and other statistics at the bottom of a datasheet,tap or click the ____ button on the HOME tab to include the Total row in the datasheet.

To delete record PLI22 shown in the accompanying figure,tap or click the record selector in the datasheet for the record on which the client number is PLI22 and then press ____.

To find duplicate records in a table,use the _____ Query Wizard.

To use a common filter to find only those customers whose city begins with G,tap or click the arrow to the right of the field name and point to the ____ command to display the custom text filters.

Restructuring the database includes adding new fields to a table,changing the characteristics of existing fields,and removing existing fields.

Validation rules can indicate a ____.

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

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