No, all of the qualifications can be attained during non-competition shooting. In fact, the only qualification that even requires a witness is the Distinguished Expert rating.
Regarding the distances, unfortunately all of the standard Pistol qualifications are done at either 15 or 30 feet. I guess the best place to do this is at Magnum...I know there's a fee and you have to use their ammo, but that's OK; I'll just give up Starbucks for the week(s) that I decide to shoot there.

Honestly, the first few qualifications seem easy enough to be done on the same day.
For the Bullseye stuff, we can use the B-8 (slow fire) and B-16 (timed and rapid fire) targets at 25 yards, so all of that stuff can be done at Koko Head.
I know that the B-8 and B-16 targets can be bought locally, I haven't looked for the AP-1 or AP-2 yet...it's actually on my list of things to do tomorrow.
- Alex