As far as the USB-6341, it is an X-series DAQ device which means it will be very well suited to do accelerometer measurements. Effectively, as long as your accelerometer can output a voltage, you will be able to acquire it at 16-bit of resolution and up to 500 kS/s.
We do not really suggest any specific sensor for DAQ devices - that becomes ultimately really up to you. Here is a useful link that could get you started:
Choosing an Accelerometer Measurement System (http://www.ni.com/white-paper/7254/en/)
Hope this helps!