Microsoft® Office Access 2003 Step by Step

Chapter 6 Keeping Your Information Accurate

Using Lookup Lists to Restrict Data To specify data type settings

1. Display the table in Design view.

2. Click in the Data Type cell of the field you want to change, click the down arrow, and then click the data type you want.

Using Field Size Properties to Restrict Data To set a field’s size property

1. Display the table in Design view.

2. Click in the field you want to change, and then in the Field Properties area, click in the Field Size box, click the down arrow, and change the setting to what you want.

Using Input Masks to Restrict Data To create a custom input mask

1. Display the table in Design view.

2. Select the field for which you want to set an input mask, and in the Field Properties area, click Input Mask.

3. Click the ...