There are a few sites that can help you learn how to create amazing Intro's and Outro's, My best tip would be to use google and type "(Program Name Here) Tutorials".
That is what I did Sony Vegas 9.0d and Adobe After Effects CS5
(Yeah that's right I have CS5, not just the stand alone either, the Master Collection)
Here what is possible with After Effects:
I Know the sound effects are repetitive but that was back when I was learning,
This ending screen was my promotional entry for MPGH Publicist position competition, I used this to promote MPGH's upcoming CA VIP