When to create a new table?

[StargateFan]

Is there any criteria that anyone here uses for deciding when to
create a new table or when one would just add info to an existing one?

Is there some sort of general guide or rule of thumb for this?

Thank you!

 

[tina]

Access was designed to support the relational data model, so the best way to
fully leverage it's power is to adhere to relational design principles when
you build your tables/relationships. for more information, see
http://home.att.net/~california.db/tips.html#aTip1

hth

 

[John Vinson]

Is there any criteria that anyone here uses for deciding when to
create a new table or when one would just add info to an existing one?

Is there some sort of general guide or rule of thumb for this?

Thank you!

You will need to create a new Table when your data model contains an
Entity which is not represented by an existing table.

If you're thinking of creating a new table with exactly the same
fields and structure as an existing table... the answer would be
Basically, Never.

John W. Vinson[MVP]