I was wondering if you all could suggest the best way to learn more about access. I love access but I know there is so much more to learn than what I know. I want to be able to write the advance programs as well as the ones I am writing right now. I know all the basics such as forms, subforms, queries, reports, macros. Where would be a good place to explore to continue my learnign

Once you get into VBA, Access becomes a vast topic. VBA can integrate with other Office programs and at the extreme level actually control the Windows Operating System.

Beyond the basics it is impossible to say what is the most important stuff to learn because that depends on what you are trying to do. Moreover it isn't something that you sit down and learn in an intensive week long course but something that infuses over a few years of experience. To a considerable extent programming is an art.

Just choose a project as complex as you care to try and get started on it.

You can Google your way to a lot of information and what you can't find we can help you with.

Here's a good place to start:

Fundamentals of Relational Database Design:
http://www.deeptraining.com/litwin/dbdesign/FundamentalsOfRelationalDatabaseDesign.aspx