Database Reference
In-Depth Information
Key points
▪
The Data Type setting restricts the data that can be entered into a field to a
specific type.
▪
The Field Size property for the Short Text, Number, and AutoNumber data types re-
stricts the number of characters allowed in a Short 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 acceptable data. Access tests entries
against the rule and rejects any that don't comply.
▪
For fields with a fixed set of possible entries, a lookup list ensures consistent data entry.
▪
If it is important that values in one table match values in another, you can create a
lookup field based on that table to keep entries accurate.
6
