What you want to do is called "compositing" and AE is a basic compositor. Depending on your needs it should work out just fine. If you plan to do this regularly, I would look into "Combustion" or other more powerful compositing software. Final Cut is pretty good as well.