Presence check, ensures that field is not left empty, ensures correct data type is used, ensures that field is of a certain length, ensures that data entered is within a range , Length check, ensures the field is required, the field size must be 255, limits the number of characters in a data field, the value must be within a range , Type check, field must not be left blank, field value must be of a certain font, value must be of a certain value, most appropriate data type has been used for that field, Format check, ensures data is of the right size, ensures field is not left empty, ensures that value entered is valid, ensures a data field is structured in the right way, Range check, field is of a certain size, field is of a certain data type, field has a particular format, data being input is between two limits, Data validation ensures that data is , sensible & reasonable, of the correct data type, of the correct format, is an exact match, Lookuplist, data entered must be number, data entered must be a character, data entered must be limited to a number of pre-defined choices, data entered must come from another table, Lookup table, another table used to store data, data entered is taken from another table , data entered must be in table form, there is no such thing, Validation rules are used to:, make the designer's job harder, make sure the designer does not break the rules, further control the values that can be entered into a field, reduce data integrity, Validation Text is used to:, produce an error message if the rule is broken, provide a description of the rule for the designer, increase data duplication, increase storage capacity, >=1 and <=20, will accept 25, will accept 0, will accept 19, "Classical" or "DJ" or "Jazz" , classical, dj and jazz must be entered, none of these words must be entered, either one of these words will be accepted, disco will be accepted, <Date(), only today's date can be entered, date entered must be in the future, date entered must be in the past, a date will not be accepted at all, Input masks, are used to hide data, are used to allow any value to be entered, are used to further limit the data that can be accepted, are used to check that all PLTFR are present, Which of the following are most suitable for input masks?, medical notes, first line of an address, postcodes, boolean values.

Data Validation & Input Masks

by
Print
Embed

Leaderboard

Visual style

Options

Switch template

Continue editing: ?