Complete Tutorial For Data Integrity Techniques

Share this post!

Vote this!

The database designer is responsible for incorporating elements to promote the accuracy and reliability of stored data within the database. There are many different techniques that can be used to encourage data integrity, with some of these dependant on what database technology is being used. This article will concentrate on the different types of data integrity techniques available whilst working with Microsoft Access:

• Referential Integrity
• Cascade Updates & Deletes
• Business Rules and Levels of Enforcement
• Field Level Integrity
• Using Field Properties
• Data Types
• Entry and Editing Constraints
• Other Data Validation Techniques
• Table Level Integrity
• Field Comparisons
• Validation Tables

More...

RECOMMENDED READING

Database Corruption and Prevention

Database Corruption & Repair 

Access Database Repair and Recovery Software: