Exam 6: Access: Maintaining a Database

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

If you plan to move your data to SQL Server at a later date,do not use ____________________ fields.

To add a new record using Form view,tap or click the New (blank)record button on the Navigation bar.

To sort the data that appears in a datasheet on multiple fields,the major and minor keys must be next to each other in the datasheet with the major key on the right.

In the type of relationship between the Book Rep and Customer tables illustrated in the accompanying figure,the infinity symbol indicates that one book rep is related to _________________________ customers.

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 format symbol.

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

Validation rules are rules that a user must follow when entering the data.

To use Filter By Selection to find all customers located in Greer,tap or click the City field for any record where the city is Greer and then tap or click the ____ button on the HOME tab.

To create a multivalued field,create a ____ field being sure to check the Allow Multiple Values check box.

When you use Advanced Filter/Sort to filter records using complex criteria,create the filter and then tap or click the ____ button on the HOME tab to view the results.

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.

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

The wildcard symbols for use with filters are ____.

If the Customer Number field in a record always should display the three characters in the customer number in uppercase,then the correct format for this field is ____.

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.< -The message that will appear if a user violates the validation rule.

A multilookup field is a field that contains more than one value.____________________

A secondary key is a field in one table whose values are required to match the primary key of another 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.< -Field that can be computed from other fields.

To delete a field from a table,open the table in ____ view,tap or click the row selector for the field to be deleted,and then press the DELETE key.