1) When members apply online (using online membership application form) they specify password.
2) When administrator creates new member record manually, password is generated and sent to the member email
3) When you import members (from an Excel file) you can specify passwords
Let us know if this helps or you have further questions.
Dmitry Buterin, Chief Apricot