Minitman,
There are a lot of resources for learning Access. However, resources for
learning VBA are somewhat more difficult to find. With that said, I would
suggest that you purchase a couple of good books. One to learn Access
(specific to your version) and another to assist you with learning and using
VBA.
I assume from reading between the lines of your post that you are most
likely already using VBA in Excel. If this is the case, you just need to
learn the various objects and methods that you would need to use VBA in
Access. It it essentially the same language, just different objects and
methods.
I would also suggest that you start with learning to design and normalized
your database structrue. The design of the data is the most critical to the
successful use of a database. Start with the most simple application that
you have on your plate as a place to learn and then you can move on to the
more complicated applications.
Once you have the design of the data (tables and relationships) then you can
start to learn the use of the user interface (queries, forms, reports, etc)
to allow your users to use the database. It is at some point following much
of this learning curve that you will need to implement the use of VBA.
I hope this will at least get you started in the right direction. As you
start to learn, come back here and post your questions, being specific as to
what you need to know. I am sure someone here will be able to help you.
