Data Validation (Grade 12 NSC Matric Computer Application Technology): Flashcards
📚Flashcards
Practise the cards
10 cards from this deck
ShowHide
Practise the cards
10 cards from this deck
Data validation
Data validation
Checking info accuracy, format & type before database storage
Purpose of data validation
Purpose of data validation
Maintains data integrity & ensures database reliability
Data type check
Data type check
Ensures info matches expected data type (e.g. numbers not letters)
Range check validation
Range check validation
Ensures numerical data falls within specific limits
Lookup column
Lookup column
Dropdown list of predefined values to choose from
Input masks
Input masks
Guide users showing how info should be formatted
Validation rule: <>0
Validation rule: <>0
Must enter a non-zero value
Validation rule: <Date()
Validation rule: <Date()
Date must be in the past
Input mask char: 0
Input mask char: 0
User must enter a digit (0-9)
Input mask char: L
Input mask char: L
User must enter a letter