to the forum...
Setting up a normalized structure is part Art, part Science. There are a lot of very talented people that are willing to help, but it helps to know where you are in the process.
What tables/fields do you have so far? Would you post them? A pic of the relationship window?
Since you are in the design phase, use only letters, numbers and/or the underscore in object names - no spaces or special characters.
No look up FIELDS (different than look up tables). See
http://access.mvps.org/access/tencommandments.htm and
http://access.mvps.org/access/lookupfields.htm
Be aware of reserved words. See
http://allenbrowne.com/AppIssueBadWord.html
Will more than one person be using the dB? If so, it should be split into a front end (FE) and a back end (BE).
And so begins your journey....