|Video cards never supply the audio, you will need to run audio from the sound card.|
Some newer cards take spdif input from the motherboard or sound card to output audio over HDMI.
To connect via composite video(the single yellow rca socket, normally accompanied by a white and/or red audio sockets) or S-video (small plug with about 4 pins and a plastic piece inside) you will need a video card that supports it (usually via a mini din variant) and a proper cable for the video card.
Normally the card will come with a break out cable when purchased new which supply composite, S-video and sometimes component video. These cables aren't really standardized, so if you don't have one try to get one for the same model card, failing that at very least the the same era and manufacturer, but this could be a gamble because even if the plug fits it may be wired in a different manner or be a different connector.
Making your own cable(if you can solder/get a pinout/if you are game) generally isn't an option because the the non-standard mini din plugs can be difficult at best to obtain in a solder-able or crimp-able option.
The audio will also have to be connected to the sound card. This is the easy part, 3.5mm stereo plug to twin rca cables are quite common and cheap and so are rca cables(well for average quality anyway...). It's normally fine to use the headphone jack, but if a line out is available use that. So it's simply a matter of connecting the 3.5mm stereo adapter cable to the red and white sockets(if you only have one socket then only connect on of the plugs).
Having rambled on for so long I must mention that composite and s-video outputs on video card can be troublesome and sometime refuse to work. It also has to be setup via the drivers for the video card......
Batch Variable how to