That card will work to use After Effects.
After Effects doesn't really use the GPU for much. See this page: GPU (CUDA, OpenGL) features in After Effects
Are you planning to use the obsolete ray-traced renderer? If so, it may or may not work to accelerate that. You can try ticking the "use unsupported cards" box. But, as I said, the ray-traced renderer is pretty much dead. See this: http://motionworks.net/after-effects-3d-future/