O'Reilly logo

2007 Microsoft® Office System Step by Step, Second Edition by Joan Lambert, John Pierce, Steve Lambert, M. Dow Lambert III, Curtis D. Frye, Joyce Cox

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

Key Points

  • You can set properties that restrict the type and amount of data that can be entered into an Access database.

  • You can quickly enact conditional changes by running an action query.

  • The Data Type setting restricts entries to a specific type of data: text, numbers, dates, and so on. The Field Size property for the Text, Number, and AutoNumber data types restricts the number of characters allowed in a text field or the number of digits allowed in a number or AutoNumber field. The Input Mask property controls the format in which data can be entered.

  • You can use a validation rule to precisely define the information that will be accepted in one or several fields in a record. At the field level, Access tests each entry against the rule when you ...

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