I would start here
8100 Series FAQ's - BlackBerryFAQ
They have put a lot of work into these FAQ's and they are awesome for shortening the learning curve! You will find TONS of great information on your device.
To answer your specific questions
Highlight your profile icon (Looks like a speaker)
Scoll to Advanced>select
Normal should be highlighted
Menu>edit
From there you can configure text and your various email accounts for notification.
Hope this helps!
E-
Edit!!! Just go here, it even has pics!!
How do I edit my notification tones (profiles)? - BlackBerryFAQ