NormalizeDenormalize.mdb (intermediate)

Please consider donating $1 per sample downloaded, find out why here
Access 97 (34 KB)

There are two modules here 1) Normalize and 2) Denormalize.

"Normalize" takes the data in table2 and creates table1. It illustrates how to take a table which has fields like Value1, Value2, Value3,... and write them into a table which has one field (Value) with each of the values in a new record rather than having them all in one record. In other words, it normalizes the table. (At least that part of it.) Thus it takes non-normalized data and puts it into a normalized form.

There are 4 subs/functions. "NormalizeTable" is the main sub which calls the others. "CreateNormalizedTable" deletes table1 and then recreates it. This is not strictly necessary, but it makes it unnecessary to make sure there is an existing table. "NormalizeIt" does the normalization. It calls "NumberOfFields" which find the maximum number of fields in table2 so the FOR loop know how many times to execute.

Denormalize takes the data in table1 and creates table2. Thus it does just the opposite and denormalizes a normalized table. This also has 4 subs/functions. "DenormalizeTable" is the main sub which calls the others. "CreateDenormalizedTable" deletes and re-creates table2. It calls "MaxNumberOfFields" to decide how many fields to create. Lastly, "DenormalizeIt" does the denormalization.

To execute either, go the appropriate module, put your cursor in the first sub, and push the execute button.




Need Winzip?

Return to Main Page