O'Reilly logo

Hands-On Microsoft Access: A Practical Guide to Improving Your Access Skills by Bob Schneider

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

Table Properties

Besides field properties, there are table properties. The table property sheet is available in Table Design view by selecting View, Properties.

Perhaps the two most significant table properties are the Validation Rule/Validation Text combination. Just as you used a validation rule to limit the range of values in a field, you can use a table property sheet for a rule that applies to two or more fields.

An Orders table presents a typical example. Suppose you have two fields for the number of units in stock, one for the head office (HeadUnits) and one for the branch office (BranchUnits). The total of the two fields shouldn't exceed 100 units for any one item. The way to ensure that is to enter a validation rule of [HeadUnits]+[BranchUnits] ...

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