Design Normalisation

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Roger Bell - 12 Apr 2005 08:52 GMT

I have inherited a flat data base that has something like
50 fields, a heap of queries, forms and reports. I need
to Normalise the table and fields. Is it better to start
from fresh and then recreate all the forms, queries,
reports etc again, or work on a new model from the
existing table.

The existing table has fields like Namechild1,
Namechild2, Involvement1,Involvement2 to mention a few
which obviously causes redundancy and other problems. It
is basically a Members data base.
Thanks for any help

Reply to this Message

Allen Browne - 12 Apr 2005 13:53 GMT

Once you have created your normalized tables, you will find that the
existing queries are no good, as they use the old tables.

The forms and reports all use tables and queries as their RecordSource, so
once you have redesigned the tables and queries you must redesign them as
well.

The upshot is that you will have to recreate the whole thing.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

>I have inherited a flat data base that has something like
> 50 fields, a heap of queries, forms and reports. I need
[quoted text clipped - 8 lines]
> is basically a Members data base.
> Thanks for any help

Reply to this Message