carduel,
I recommend that you
work through 1 or 2 of the tutorials from RogersAccessLibrary mentioned in this
link. You will experience a process to identify tables and relationships. You can then apply the same process to your own project and test your design before getting too deeply into Access. You will learn more about table and relationships in 30-45 minutes than a lot of trial and error.
It all starts with a clear description of the problem/opportunity to be supported with a database. And, like any construction project, it goes through concept, analysis and design to blueprint before "the digging/building" starts.
Good luck with your project.