BTEC ICT Databases 0.0 / 5 ? ICTRelational Database DesignsBTEC NationalEdexcel Created by: HowzatCreated on: 18-01-18 16:14 What does validation do? Checks if the data is correct/sensible. Checks for an error. 1 of 13 What would be a sensible validation technique for a gender field in a database? Lookup check for M or F. 2 of 13 What can you put if there is no specific validation technique? Is Not Null 3 of 13 What is Range Check? Makes sure that the data is between 2 values. Such as "10 to 20" 4 of 13 What is Presence Check? Checks data has been entered into a field. Normally a Primary Key. 5 of 13 What does the Input Mask '0' mean? Any number between 1 and 9 can be entered. 6 of 13 What does the Input Mask '#' mean? It means inputting a number is optional and must be 1-9. 7 of 13 What does the input mask 'L' mean? A letter from A-Z must be entered. 8 of 13 What does the input mask '?' mean? Inputting a letter is optional and must be between A-Z. 9 of 13 What does the input mask 'A' mean? A number or letter must be entered. 10 of 13 What does the input mask 'a' mean? An entry is optional, but must be a letter or digit. 11 of 13 What does the input mask '&' mean? Any key must be entered. 12 of 13 What does the input mask '\'? Any character following '\' will be shown on screen. 13 of 13
Comments
No comments have yet been made