Data redundancy is a data organization issue that allows the unnecessary duplication of data within your Microsoft Access database. A change or modification, to redundant data, requires that you make changes to multiple fields of a database. While this is the expected behavior for flat file database designs and spreadsheets, it defeats the purpose of relational database designs. The data relationships, inherent in a relational database, should allow you to maintain a single data field, at one location, and make the database’s relational model responsible for porting any changes, to that data field, across the database. Redundant data wastes valuable space and creates troubling database maintenance problems.
To eliminate redundant data from your Microsoft Access database, you must take special care to organize the data in your data tables. Normalization is a method of organizing your data to prevent redundancy. Normalization involves establishing and maintaining the integrity of your data tables as well as eliminating inconsistent data dependencies.
Establishing and maintaining integrity requires that you follow the Access prescribed rules to maintain parent-child, table relationships. Eliminating inconsistent, data dependencies involves ensuring that data is housed in the appropriate Access database table. An appropriate table is a table in which the data has some relation to or dependence on the table. Allow NYDS experts to assist you with your IT infrastructure.