if I import a 3ds max form "model" into the After Effects can I Manipulate it and apply any type of effect on it ??
Sorry, that's incorrect. That's a tutorial for rendering an image sequence for use in AE. It has nothing to do with importing a 3D model a 3D application into AE. If you were to turn that sequence into a 3D layer, you would see that once you rotated it, it's still 2D... just rotating in 3D space. There's no depth to it.
I don't know what "terrain scan" means, but Dave is correct: when you render video from a 3D application and import it to AE, it is a flat video file. It has nothing to do with the question of importing 3D models, and retains no 3D characteristics within AE.
The only way to deal with true 3D object imports in AE is to use Photoshop Live 3D import, as Mylenium mentioned, or a third party plugin like Zaxwerks 3D Invigorator.
Exporting cameras from one program to the other seems to be pretty easy, and makes working with the PNG sequences not as limiting as you may think. Lets say you have a camera move in 3ds or any other program, with your model (lets assume the fighter jet from the tutorial). You render out the animation with an alpha channel. Then export the 3d camera for After Effects. Bring it in to After Effects, and you have a 3d camera that mimics the exact moves from the camera in 3ds. You now have your PNG sequence, but this is left as a 2d layer. Anything that is made a 3d layer will move as they should with the perspective given by the 2d layer. You can easily composite skies, elements, whatever you may want.
After all, AE is a compositer first, with some incredibly awesome capabilities. The drawback is that it doesn't do true 3d geometery out of the box, and even with plugins it's limited. With a 3d program and After Effects combines, however, that's power.
As the others already said, you are seriously misunderstanding pretty much every part of the tutorial and it's obvious that you are a beginner. Therefore astart here.
Mylenium
North America
Europe, Middle East and Africa
Asia Pacific