O'Reilly logo

Microsoft® Office Access 2003 Step by Step by Online Training Solutions Inc.

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required