This is a great starting point, having 37 well written, well defined, clearly named chapters...as well as a half dozen complete database examples:
Microsoft Access 2010 Desktop Databases
And the first thing you really need to do is to learn the ABCs of Access...literally! Learn the names of the various Objects! What a Form is, a Field is, a Control is...the difference between a Combobox and a Listbox...etc.
One of the biggest problems we face, here, and on other Access forums, is that many newbies can't ask a clear question simply because they don't know the proper words to use to describe their problems! Sometimes we can guess what is being asked, but I've seen threads where members posted beacoup responses, only to finally discover that what the OP said and what they meant to say was totally unrelated!
And continue to ask questions, using threads with appropriately titles! Titles such as 'Please Help!' or 'Code Doesn't Work' will often receive no responses at all...while 'Learning VBA' tells everyone pretty much what your question was going to be!
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007