Jeff, I hope some of the following will help. It's not cast in concrete. Others should jump in & offer their experience too.
1. If the compressor you're using has an air tank & an air regulator, it will hold a constant psi while in use. If you're using a diaphragm compressor, it'll drop.
2. I wasn't familiar with this Aztek compressor, so I looked for it on the net. Max. psi is 40. This compressor is the diaphragm type without an air tank, that's why it drops in use. I would say it probably doesn't have enough psi for spraying acrylic paints.
3. I would recommend an oilless compressor with an air tank, an air regulator, & to use a moisture trap. I bought a pancake compressor sold by Rockwell, Sears, & others a few years ago. It's not real quiet, but supplies plenty of air for airbrushing. The air tank stores about 120psi.
4. Needle sizes will vary with the airbrush & what medium you're spraying. What are you using? Two of my airbrushes are Azteks. About 8-10 needle sizes are available for them. Some people don't like these brushes, but I do. While not a high-end brush, they work for me. I also have a Paasche with several interchangeable tips & an old Binks with a medium tip. I won't bother to discuss single-action & double-action airbrushes, only to say I wish I had learned to airbrush on a double action airbrush.