It's a common data cleansing challenge: how do you eliminate duplicate data from multiple systems without accidentally deleting unique data?

Sometimes the two primary goals of database normalization--reduced data redundancy and improved data integrity--are at odds with each other.

The most important phase of any Microsoft Access application project is the database design. This site has tons of sample schemas to get you started.

Are single-row tables something you should use or not? Can they be trusted? I answer that and more in this installment of Reader Q&A.

Database tables in a line-of-business application generally fall into one of these thirteen categories.

Introducing the "Numeroliteral Test," a one-question heuristic for deciding whether to store numeric data in a character-based field.