Simple Question

[Justin]

Seems to me that most of the 120 pages of posts are not
from people "getting started".
Anyway, for my question, do I need to know, or be
familiar with Visual Basic or VBA before delving into
developing databases, or everything I need built into
Access?
Any advice would be welcome before I dump money on books
I don't need. I have tried to find an answer to this
question on the net to no avail.
Thanks

 

[Rick Brandt]

Seems to me that most of the 120 pages of posts are not
from people "getting started".
Anyway, for my question, do I need to know, or be
familiar with Visual Basic or VBA before delving into
developing databases, or everything I need built into
Access?
Any advice would be welcome before I dump money on books
I don't need. I have tried to find an answer to this
question on the net to no avail.
Thanks

IMO:

If you're goal is to build simple little applications for your own use or for a few
colleagues at work, then you might get by with Wizards and Macros. If you're goal is
to develop anything really useful or complex, then you will need to learn VBA. One
big reason is found by looking at these newsgroups. You will find _very_ few
solutions offered that don't require use and/or knowledge of VBA. Many Macro
questions go wanting of answers because those more familiar with Access rarely use
them.

 

[Van T. Dinh]

-----Original Message-----
Seems to me that most of the 120 pages of posts are not
from people "getting started".
Anyway, for my question, do I need to know, or be
familiar with Visual Basic or VBA before delving into
developing databases, or everything I need built into
Access?

VBA IS a component of Access software. You can do a lot
of things in Access without using VBA but you can do MUCH
MUCH MORE if you use VBA. So, the answer is that you can
start without knowing VBA but but the you seriously use
Access, you will want to learn and used VBA.

There are a number of books that cover a whole lot of what
you can do in Access without using VBA and then introduce
VBA later. I found Roger Jennings' "Using Access
{YourVersion}" is particularly useful in this (VBA starts
in chapter 28 of about 33 chapters in the Access 97
version of the book). However, you should browse a well-
stocked bookshop to find which one suits your learning
style.

HTH
Van T. Dinh
MVP (Access)

 

[Cardo Davi]

-----Original Message-----
Seems to me that most of the 120 pages of posts are not
from people "getting started".
Anyway, for my question, do I need to know, or be
familiar with Visual Basic or VBA before delving into
developing databases, or everything I need built into
Access?
Any advice would be welcome before I dump money on books
I don't need. I have tried to find an answer to this
question on the net to no avail.
Thanks
.
Simple Answer - No you don't have to know VBA or Visual

Basic to develop databases if you follow the many simple
tutorials available. The good news is if you want to
develop, or further customize data bases you will become
exposed to VBA in a non threatening way, and you will be
able to pick up the parts you will need eventually.
Good luck,
Remember, it's the journey that counts, just as much as
the destination.
Cardo

 

[Justin]

I thank both of you. I have to develop both simple
databases and one relatively complex one, as well as try
to reverse engineer an extremely complex one (to me,
anyway)that was created by a friend who received orders
to another country recently. I am trying to learn as much
as I can before he leaves. As luck would have it, my base
library had one well used copy of "Using Access 2000".
Again, thanks for your help, it is greatly appreciated.