Exam 7: Enhancing Table Design

Describe a lookup property and explain the advantage of using one. Be sure to include a discussion on how to set lookup properties and the three forms of lookup property boxes.

Case Access 7-2 Andrew is an accountant with a large investment firm in New York. He keeps an Access database of travel expenditures for all of the auditors within the Oversight and Supervision Division. His database is updated nightly as part of the Computer Operations critical path runtime workload. During your initial discussion with Andrew, he raises a concern regarding how changes to the field data will affect his calculations. You explain to Andrew that if an amount in either of the fields changes, the result in the calculated field ____.

When saving data entered with an input mask, if your computer has plenty of ____, it should be okay to save the values with the symbols.

After the input mask is created, placeholders appear in the ____ until the values are entered.

When applying validation rules to data, a(n) ____ appears if the data is entered incorrectly.

A placeholder appears in a field ____ the value is entered.

When you create lookup properties in the Lookup pane, your selections are limited.

To create an input mask, you select the field for which you want to create the input mask, and then click in the Input Mask ____ in the Field Properties pane.

When setting lookup properties, if Table/Query is the Row Source Type, you need to select the table or query for the Row Source.

The ____________________ takes you step-by-step through the process of creating an input mask.

An input mask can only be applied to fields with date data types.

An input mask is a pattern for common types of data entered in a field.

Figure AC 7-1 In the accompanying figure, the completed expression will appear in the area represented by item ____.

A validation message appears when data entered into the field meets the validation rule.

You must enter data before you can see how an input mask will display data.

To have more than one field appear in a lookup field list, you need to create lookup properties using the ____________________.

After you set the lookup properties for a field, a drop-down ____ will appear in the field when it is selected.

The Expression Wizard is where you type, or build, an expression.

A(n) ____________________ is a predefined format that can be used with fields that contain data, such as dates and Social Security numbers.

A placeholder identifies that an input mask is assigned to the field in a table.