We can't build your database for you. I understand that you are new to DB programming, and that is fine. But, just realize that you must put forth an effort of trying to learn about Databases first, and give a reasonable try before we can/will assist you.
There are numerous sources for MS Access Tutorials, to include the MS Northwind Database which provide numerous examples of a basic design.
Bottom line: We would love to help and assist where we can, and your solution is very simple. But if you don't know even the absolute basics of DB design and query building, then you should start with the basics before asking for project solutions.
Please don't think I am being short or dismissive. We would love for you to use Bytes as a source for your learning, but the experts on this forum will not do your work for you. We will trouble shoot your errors and offer advice on better designs, when feasible.