I've been tasked to train a new MS Access developer that's moving into my department in a couple weeks. I'm not completely certain what his knowledge level is, but from what I've seen he knows very little if anything about basic design concepts like normalization. I don't think he even knows much VBA and is still primarily macro/wizard driven. There's no budget in my department for training, so free options are the only ones I could use. What resources could be recommended to help me teach him some of the basics and start developing a foundation to build on to get him up to speed?
migrated from stackoverflow.com Jun 23 '11 at 10:38
I think my experience could be an answer.
I'm now in a factory doing my internship. One of my job is to create a Access App. When I began 2 month ago, I knew nearly nothing about Access and a little about database and VB.
Firstly I did read book. One I recommend is Access Database Design & Programming. It's not that kind of bible book, but it starts from database design theory(SQL, normalization of course), then VBA, finishes by introducing DAO and ADO model. It's not based on the modern version of Access but is still valuable. Most important is its price, very cheap.
Then I have a look at the sample database, the Northwind in Access 2007. And by studying it (interface, code, structure of the app etc.), I have a clear idea what it is like a Access App and plus some useful techniques (wrappers, log error module ...)
And of course it's here, SO. You can see I post several questions here, all are well responded.