Defining Check Constraints
Constraints are a way of limiting the values that can be entered in a column or group of columns. Constraints are handy because you can use them to enforce data consistency from your users and ensure the relational integrity of your database. You might already be familiar with some of these constraints. Access projects use a group of constraints to create elements in the table design interface that are familiar to Access desktop database (.mdb) users. These elements include the ability to specify a default value in a column, declaring primary and foreign keys, and creating a table index as a unique index.
Access projects also include the ability to create additional custom constraints called check constraints for the ...
Get Microsoft® Office Access 2003 Inside Out 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.
