I agree with Arvi.
Here is a
link to various info in different formats re Database Concepts, Planning and Design.
I recommend you review some of the videos for general concepts (tables, relationships, normalization...)
Spend some time (~ 45-60 minutes) and
work through 1 or 2 of the tutorials from RogersAccessLibrary mentioned in the link.
Pay specific attention to how he uses a description of the business to identify the parts of his database design and build a blueprint for his database. I can't over estimate the value of these tutorials and the procedure he uses to identify, design and test his model.
Work through a tutorial or 2 to understand and experience the approach. Then do the same process for your own proposed database. You'll have a blueprint for developing your database. Much easier to do on paper than to start a trial and error approach with physical Access.
You have to actually
do the exercise (
work through) to get the benefit, but you will learn -and what you learn can be used with any database.
You may also
get some insight from this link.
Good luck with your project.