what are two of the rules for validation?
Data Check.
Field length check.
File check.
Input mask.
We use validation to make sure that data entered into a database is correct?
Which of these format checks should validate post codes including ones like CB1 2EU?
lL09 L00
LL09 0LL
LL99 L00
Ll00 0LL
A presence check ensures that...
The data is within a given range.
The data is text or numeric.
Data is entered into the field.
The data is entered in a particular format.
What is an logic error?
The program would run but it wouldn't run in the why you want it to e.g if the AND / OR re the wrong way round.
Doesn't run if the rules are spelt wrong or if the rules aren't entered proper.
What does Real mean in a database?
It's a whole number.
It's a decimal number.
It's a Yes/No, True/False or On/Off.
Can be with single quotes, double quotes or triple quotes.
