Database
I started off my creating 2 databases which included all the data types listed on the SPB. I insured that each field had a suitable data type, format and length.
Then in one of the databases I used validation rules on the following fields:
ID - Only allowing 3 or 4 digits
TYPE OF ACTIVITY - Only allowing the listed codes.
WEB ADDRESS - Making sure that the hyperlink code is formatted right.
On all the other fields I used a validation rule to check that the field was not left blank. Except for the POSTCODE or TELEPHONE fields as these were allowed to be left blank.
I then tested the database and got a test user to also test it. It worked fine and rejected the records i purposely entered wrong.
I then imported the Data Sheet into both of the databases and set up a 'Find Unmatched Query' to find the rejected records (the ones that were in the non-validated Data Base but not in the validated Data Base).
Here are the 4* rejected records found: 0401
Rejected Records.
* One of these isn't rejected by a validation rule really, just a field was
required but no data was included for that field (ID: 1224).
I then check the database against the text document and made sure all the data was imported correctly.
Screen Shots
- 0402 Database Structure
- 0403 Validation Evidence (SWF File)
- 0404 Unmatched Query Design View (Rejected Records)
- 0405 Unmatched Query Results (Rejected Records)
Page 1 2