Profiles>advanced>active profile (or the profile you want to edit (loud, normal) then select the alert you wish to edit (SMS, MMS, EMAIL, PHONE) pick a tone and save. From this menu you can customize it to your liking for each alert..
Welcome to CrackBerry - be sure to check out the Blackberry Lecture Series in my signature, tons of good info for ya there....