Entering Personnel Actions Table Data and Testing Validation Rules
You can experiment with entering table data and testing your validation rules at the same time. Testing database applications often requires much more time and effort than creating them. The following basic tests are required to confirm your validation rules:
Referential integrity. Type 25 in the paID field and 2 in the paInitiatedBy field of the default blank record, record number 10, and then press the up-arrow key. Pressing the up-arrow key tells Access that you are finished with the current record and to move up to the preceding record with the caret in the same field. Access then tests the primary-key integrity before enabling you to leave the current record. The message ...
Get Special Edition Using Access 97, Second Edition 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.
