How do you know when to create another table for the information vs. putting all the information in one table?
Reply from Richard Rost:
This is a very good question. I could easily spend an hour discussing this topic - called "normalization." USUALLY when you have information that's going to be DUPLICATED amongst multiple records, you want to spawn that off into it's own table. For example, if you're tracking orders and you have repeated customer information (name, address, etc.) on multiple orders you would USUALLY want to split that off into its own table (a customer table). There are exceptions (which I talk about in my classes). I go into a lot more detail on this topic once we get into multiple-table databases, starting with Access 201.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Beginner 3.