What Is “data Integrity” in Microsoft Access?
In Microsoft Access, data integrity refers to the values that are used and stored in the data structures of an application. To ensure data integrity the application must be able to control every data-using process so that the information being produced continues to be correct.
Microsoft Access has four methods to maintain data integrity: normalizing data, defining business rules, providing referential integrity and data validation. Data normalization is a process where unnecessary dependencies and repeating groups of data are eliminated. Business rules for data access control data handling and sharing between applications. Referential integrity is used to protect data from corruption. Data validation uses multiple processes to validate data in the application.