How do I texture models?

I dont know to actually texture my models. Do you have to make the skins your self in 3DS max (Or whatever your using) or in photoshop or something similar.

Cheers.