Yes you can do it in after effects but if you have never used it at all it is not that easy. If you have little to no experience with creating videos AE will be tough to learn. Also AE is not a cheap program.
Motion is much cheaper but more simplistic. I am not sure if it will do exactly what you want as I have never tried the particular project you are looking into.
Either way you will have to give one or the other a try. I know Adobe will let you download a free trial of After Effects.