FWIW, Access is easy to do poorly, and having an Excel paradigm will only hurt you. Suggest you at least read up on normalization and other vital topics for beginners. Skip that and you might just build something that will thwart you every step of the way. Here's a set of links to get you started. If they don't appeal to you, find others on the subject(s) that do.
In addition to these, there's tons of youTube videos worth investigating
Normalization is paramount. Diagramming maybe not so much for some people.
Normalization Parts I, II, III, IV, and V
http://rogersaccessblog.blogspot.ca/...on-part-i.html
and/or
http://holowczak.com/database-normalization/
Entity-Relationship Diagramming: Part I, II, III and IV
http://rogersaccessblog.blogspot.ca/...ng-part-i.html
How do I Create an Application in Microsoft Access?
http://rogersaccessblog.blogspot.ca/...cation-in.html
Important for success:
One source about how to name things - http://access.mvps.org/access/general/gen0012.htm
What not to use in names - http://allenbrowne.com/AppIssueBadWord.html
About Auto Numbers
- http://www.utteraccess.com/wiki/Autonumbers
- http://access.mvps.org/access/general/gen0025.htm
The evils of lookup fields - http://access.mvps.org/access/lookupfields.htm
Table and PK design tips - http://www.fmsinc.com/free/newtips/primarykey.asp
About calculated table fields - http://allenbrowne.com/casu-14.html
That should get you started.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.