The Revolver can be obtained in Mission 3 – Encounters. Fairly sure this is story related as there is a key card you have to get in order to progress and the revolver is right next to it.
In order to get this achievement you only have to fire the revolver, it doesn't have to hit anything.