To answer my own question,

I know that many of you have been scouring the web looking for an answer to
my questions: how to learn the Russian alphabet? is there an alphabet song?
how will I ever find anything in the translation dictionary if I don't know
alphabetical order?

Well, never fear, I have found a solution to my alphabet problem: Alphabet
letter-by-letter .
It's an exe file that plays the alphabet for you with audio and visual. It's
just right for me.

So thanks to all of you who have been helping me with my Russian alphabet
quest. I've luckily answered my own question.