After you press ~, do you see half the screen coming down?
If so, you can start writing commands such as "name abc" or "votemap 2" etc.
If you don't see anything happen after you press ~ then you need to go to the shortcut icon that you click on to go into CS, right click -> properties, change the Target to "...\Sierra\Counter-Strike\cstrike.exe -console"