No, you can't just make a hash out of a password, smack it into any client and expect it to work.
These are the steps to convert it into a private key:
https://en.bitcoin.it/wiki/Wallet_import_format. That being said, its incredibly insecure to generate an address using SHA256 since its rather fast to bruteforce tons of address with weak to moderate passwords.
Is it possible to check on an offline computer which bitcoin address it corresponds to? I'm thinking about creating a brain wallet on an offline machine to store bitcoin on. Thank you for any help

Yes, there are various scripts to do so, eg. Bitaddress.org.
I really cannot recommend anyone generating an address with a password and expecting it not to be compromised in a short time. You can generate addresses on Bitaddress.org, don't use the brainwallet function.