Database normalization in MS Access follows three main normal forms: First Normal Form (1NF) eliminates repeating groups, Second Normal Form (2NF) removes partial dependencies, and Third Normal Form (3NF) eliminates transitive dependencies. These three forms are the foundation of database design.