Cambridge Nationals IT: LO5.1 Data Validation

Presence Check is

• checking that the user has entered data into a required field

• checking that the required amount of characters has been entered

• checking that the data entered follows a specific format or pattern.

• checking that the number entered is within a specific range.

Length Check is

• checking that the user has entered data into a required field

• checking that the required amount of characters has been entered

• checking that the data entered follows a specific format or pattern.

• checking that the number entered is within a specific range.

Format Check is

• checking that the user has entered data into a required field

• checking that the required amount of characters has been entered

• checking that the data entered follows a specific format or pattern.

• checking that the number entered is within a specific range.

Range Check is

• checking that the user has entered data into a required field

• checking that the required amount of characters has been entered

• checking that the data entered follows a specific format or pattern.

• checking that the number entered is within a specific range.

Input masks are what kind of data validation?

• Presence check

• Length Check

• Format Check`

• Range Check

A required field is what kind of data validation?

• Presence check

• Length Check

• Format Check`

• Range Check

Only allowing 35 characters is what kind of data validation?

• Presence check

• Length Check

• Format Check`

• Range Check

Only allowing between 1900 and 2020 is what kind of data validation?

• Presence check

• Length Check

• Format Check`

• Range Check

Choosing from a list is what type of validation?

• Lookup value

• Presence check

• Range Check

• Format Check

Why does a database use validation?

• To ensure that the data entered is sensible

• To ensure that the data entered is correct.

• To ensure that the data entered is saved.

• To ensure that the data entered is spelt correctly.