Grade 8: MS Access Data Validation

Front

What is a field?

Back

A collection of the data about one aspect of every record in a database, such as date of birth

Front

A validation rule is: DD/MM/YYYY. What type of check is this?

Back

A format check

Front

A validation rule is: Characters < 50.

What type of check is this?

Back

A length check

Front

What does null mean?

Back

Unknown or missing

Front

A validation rule is: is NOT NULL.

What type of check is this?

Back

A presence check

Front

What is a primary key?

Back

To make sure that search results are correct

Front

What is validation?

Back

Checking rules to make sure that data entered into a field is correct

Front

A validation rule is: Value > 0 AND < 20. What type of check is this?

Back

A range check

Front

What does data format mean?

Back

Refers to the structure of the data in a field

Front

What is a wizard?

Back

A tool that helps you create something in software