This shop sells materials that have been used in an ALPS rated "1" college (2019 results) for the results achieved in Key Stage 5 in BTEC Nationals Extended Certificate in Information technology, and in KS4, BTEC Tech Award in Digital Information Technology. Key Stage 4 resources now available for the three components of the BTEC Tech Award in Digital and information technology course. Email:

zip, 575.72 KB
zip, 575.72 KB

**Task 2: Validation **

Students will need to understand how to include appropriate validation when designing and creating a database. This presentation gives simple examples that students will be able to build on based on a Gym example. No data has been entered, as this is something that students may do themselves once they have amended or adapted the validation rules.

The accompanying database includes examples of the following validation:

• Range Check
• Presence Check
• Format Check
• Type Check
• Length Check

There are examples of basic input masks in the database which students will also be able to build on. A list of the most common types of masks are in the presentation and students are encouraged to experiment with the different types to understand when they should be used.
There is an expectation that students will know how to set up “Value” and “Table” Lookups using Access. In the example are one of each. Bear in mind for this example, the concept of normalisation has been ignored.

Creative Commons "Sharealike"



Something went wrong, please try again later.


10 months ago

Clear and to the point. Thank you.


2 years ago

Excellent thank you

Report this resourceto let us know if it violates our terms and conditions.
Our customer service team will review your report and will be in touch.