As you stated, there are few, if any, schools, public or professional, that teach Access Programming. I created a course for the college I taught in, offered it for 4 years, and it only ran once. The college finally dropped it. It seems Access programming is just too daunting for the average, occasional Access user.
I can suggest two books:
Access Progamming for Windows for Dummies (yeah,right) and Step by Step Microsoft Access Visual Basic by Microsoft Press.
Also, just check out all the coding in these Access forums. You'll find some amazing stuff you can use or modify.