Reply to thread

Message

[QUOTE="Jeff Boyce, post: 2569723"]
From your tag line, you may be the same person who has posted earlier
questions and been advised to look into normalization as an excellent
starting place before building tables in Access (or in any other relational
database).  From your question, I suspect you still need a bit more time
looking into the topic.

There is no "right" answer for how many fields are in a table, as this is
driven by the normalization process.  However, a rough rule of thumb is that
a well-normalized data structure will only rarely require a table with more
than 20 or 30 fields (and even this many is unusual).

Have you defined the entities and relationships?  When you say "Personal
Information" and "well over 100 fields", I don't have a clue ... can you
provide some specific examples?  It would make it easier to offer some
specific suggestions.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP

Microsoft IT Academy Program Mentor
[URL]http://microsoftitacademy.com/[/URL]

Microsoft Registered Partner
[URL]https://partner.microsoft.com/[/URL]
[/QUOTE]

Verification