Design Access databases with normal forms and Excel

To become a true Access power user, you need to understand a key database design concept called normalization. Normalization is the process of ensuring that your data conforms to sets of rules called (logically enough) normal forms. When you normalize your data, you eliminate redundant data and ensure that the information in each table is properly linked.