Ways of validating data

In addition, updates and deletes in the lookup table prevented by referential integrity occur when the data in the foreign key column of the data table is not present in the lookup table.

ways of validating data-76

Typically, referential integrity is applied when data is inserted, deleted, or updated.

The inserts and updates to the data table prevented by referential integrity happen in the foreign key column.

Data validation is often a topic of great importance when it comes to databases.

Since information is constantly being updated, deleted, queried, or moved around, having valid data is a must.

Example: Input masks can specify that social security numbers be entered in the form of ‘AAA"-"AA"-"AAAA’. "Validating Data in Microsoft Access | Database Solutions for Microsoft Access | uk." Database Solutions & Downloads for Microsoft Access | uk.

Last modified 13-Apr-2020 05:27