I've never taken a class in Access (although I may begin giving some soon). But I have to agree with sgaphotog when he says:
"The best way, in my opinion, to learn Access
is find a problem to solve and just start
plinking away at it."
(to which I would add, "... with a good Access reference book." like Access Developer's Handbook, Beginning Access 2000 VBA, or others).
It's just part of the nature of computer training classes that while you may get wide exposure to lots of different things, next to none of it will stick with you. It may help to give you an overview and get you started. But almost none of the stuff you are presented with will sink in. Later, when you've got a problem in front of you on the job that you've got to solve, you may recall that some method or other was used to solve it at the class you attended, but you're still going to have to figure it out yourself at that point.
In my opinion, learning programming is more like learning math than like simply "learning facts". To learn math you've got to work problems. To take a class on math without actually working through lots of problems by yourself -- that is, without lots of your own sweat and frustration -- is virtually worthless. A class on Access, or any other computer subject, could be really useful if were combined with lots of work on your own, unaided by a teacher. That might happen in a semester long course at a university, but it's simply not gonna happen in week long (or less) training class.
As someone said in an earlier post in this thread, these classes can be good for getting someone past their initial intimidation of working with a new program or technology. But they're awfully expensive just for that. --- Herb