The How-Tos are all very good references, but you may still have trouble finding things that go well with your skin tone, etc. Because of the acne issue you mentioned, you may want to look for make-up that is non-comedogenic (won't clog pores).
Because of your requirements, I would strongly second tekla's suggestion about a stand-alone MAC store. If that's not an option, you could always try a department store make-up counter. If you're shy, go on a slow day, like Sunday afternoon. You can usually get make-up consulting done even if you're dressed as a guy, the sales people really don't care that much, IMHO. They're really just more interested in making the sale.
If you're in a rural area, that may be harder, but short of having someone teach you, you can have a lot of problems, especially with foundation-- I bought several different kinds before I gave up, went to Macy's and had the Estee-Lauder sales lady find me the right shade. I bought it, and haven't had any trouble since.
One word of caution about MAC stores-- most of what they'll do around your eyes will make you look like a prostitute or rock goddess. You may be okay with that result, but know that most women don't do their eye makeup like that. Don't get me wrong, I love going there, and I always buy stuff, and have the girls do my eye makeup anyway, just know that it's a bit extreme. If you're going out for an evening, it'll be fine. If you need something to wear to work, then tell them you need something subtle.
In keeping with Carol's suggestion about brushes, etc.-- The really great part about a MAC store is that the girls will tell you which brushes to use for what.