Table level validation rules in Microsoft Access are an important complement to form level validation for verifying user data entry. They are the only option to validate data upon import from external files or APIs.
In this video I briefly cover Field level validation rules, which should be well-known. Then I up the game with table level validation rules covering multiple fields with multiple linked conditions. Finally, I show the mostly unknown CHECK CONSTRTAINTS verify data with a sub-select validation clause.
The topic of this video is also available in text form on my website at: codekabinett.com/rdumps.php?L...
#ValidationRules, #MsAccess, #CHECKCONSTRTAINTS
Негізгі бет Ғылым және технология Table Validation Rules in Microsoft Access
Пікірлер: 11