database
implementation in access
setting the validation rules
Now I'm going to apply all the various validation rules I designed beforehand to the appropriate fields. The first one is in the CD entity - the primary key field: CD Number. Below is a snap of this rule implemented:
All the other validation rules are in the second table: Order. The first one on that entity is the primary key's rule, below is a screendump of this field with its validation in place.
The second is just a repeat of the rule for the primary key in the other field - seeing as it is the foreign key. The third rule on this table is for the Post Code field. Below is a screenshot of this being implemented into the database:
The fourth and final validation rule I have designed for this entity is for the Card Number field. The implementation of this is shown below:
Click next to continue...