Our basis to determine whether we make it a separate table

[Frank Situmorang]

Hello experts:
What is our basis to determine that a group of deta should be on a separete
table. I found it that actually this database is very helpful in our data
management, so I tried to use access database to replace our excell.

This forum is very helpful to me. I appreciate if someone can tell the good
website explaining the above subject

Frank

 

[Jamie Collins]

What is our basis to determine that a group of deta should be on a separete
table.

Normalization (http://en.wikipedia.org/wiki/Database_normalization).

Jamie.

--