Hi, all!
I'm looking for some guidance. I'm a career insurance lady, who's suddenly found herself building two Access databases from scratch...and I'd never heard of Access until this June. I've read "Access 2007 for Dummies" cover-to-cover, have "Access 2007 All-In-One Desk Reference for Dummies", and am currently reading "Access 2007 VBA Programming for Dummies". I've been collecting sample code and resources from online, as well. But I have 0 real training for this.
My question is what websites, books, or other learning methods/materials would experts recommend?
My projects are turning out to be VERY VBA heavy, and I've even had to write a little SQL, here lately. I'm at a point where I've been able to take code from online, and tweak it to fit my database, but I'm having some difficulties writing my own, and I'm going to HAVE to learn, because both of these databases are going to require massive custom programming to achieve their primary purposes. (To give an idea of the depth, for one of them, I have a 30 page document regarding insurance requirements that I need to translate into VBA, so that users can type information from the insurance policy they're looking at into a review Form, and have the system tell them if it is good or not, and that includes scenarios in which multiple answers to other questions will affect a single requirement elsewhere. Then I have another, slightly shorter guide I have to do the same thing with. And these change every couple of years, but some accounts will still be subject to prior rules, so it has to be able to compare several bits of data to the guides, and determine which edition applies, along with which of the two major ones.)
And that's probably going to be the easy one. I could write you a novel about what my primary project is supposed to do.
What is the BEST way for a newbie to learn to program at this level?