Shoot! No reason for pushing tones and all that, just download -
Digital Clock -

And set whatever ringtone, mp3, or whatever to your alarm.
Also here is a fantastic Alarm app, called Math Alarm! You have to do Math problems, anywhere from basic arithmetic to solving for x equations to turn the alarm off. It will wake you up. It is $1.99 though.
Math Alarm Clock -
Good luck! And in case you didn't know, sorry if you do and this is annoying, but use "Barcode Scanner" from the Market to scan these QR Codes and it'll take you to their place in the Android Market. Have fun!