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] ...
Get Hands-On Microsoft Access: A Practical Guide to Improving Your Access Skills now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
