I didn't know about hardware wallet. How does it work? I mean when I have to send some coins do I need to connect it with some software via password

Just see it like a flash-drive..the way you store things inside your flash drive..