Microsoft Access - ACCESS Data Normalization - Asked By V. on 10-Sep-12 01:37 PM

A few years ago, I used an ACCESS add in program that allowed for quick data normalization within the DB.  A few clicks and a new column of data was created - no dashes or other symbols or unwanted characters.

Can anyone suggest an ACCESS add in that would allow for simple data normalization - on a large DB with close to a million records???

Thanks
Pat Hartman replied to V. on 30-Dec-12 06:49 PM
I'm not sure what you are looking for.  Adding columns to tables via program code is just the opposite of normalization.  It is what you would do with a spreadsheet, not what you would do with a relational database.  The number of rows in a table isn't relevant to a discussion on normalization.