HELP

[Guest]

I program alot in Excel but alot of what i am trying to do would be much
smaller and comprehensive in Access. What book or site can i go to for
NOOBish questions as I usualy can figure out stuff if I see an example. I
really want to start programing in Access but I am clueless as to VBA. So a
VBA for dummies that expalins allof the termology is needed also.

 

[Ed Metcalfe]

I program alot in Excel but alot of what i am trying to do would be much
smaller and comprehensive in Access. What book or site can i go to for
NOOBish questions as I usualy can figure out stuff if I see an example. I
really want to start programing in Access but I am clueless as to VBA. So
a
VBA for dummies that expalins allof the termology is needed also.

John,

Dependent on your level of knowledge you'll probably want to start with
reading up on the principals of relational database design. This isn't
platform specific - the principals apply regardless of what database
management system you are using, so Google is your friend here:

http://www.google.com/search?client...abase+design&sourceid=opera&ie=utf-8&oe=utf-8

Are you familiar with Excel VBA? If so you will probably be surprised how
quickly you will pick up Access VBA. The object model differs significantly,
but the language and sytax are still the same. Either way start with a
Google:

http://www.google.com/search?hl=en&...s=en&hs=MAO&q=access+vba+tutorial&btnG=Search

If you're willing to splash out on some books the best I have found are the
Access Developers' Handbooks (two volumes) from Sybex. If you can only
afford one get volume 1 - it's more geared towards desktop (rather than
enterprise) development).

Ed Metcalfe.

 

[John W. Vinson]

I program alot in Excel but alot of what i am trying to do would be much
smaller and comprehensive in Access. What book or site can i go to for
NOOBish questions as I usualy can figure out stuff if I see an example. I
really want to start programing in Access but I am clueless as to VBA. So a
VBA for dummies that expalins allof the termology is needed also.

There are quite a few books. There are links here:

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

John W. Vinson [MVP]