Can you use a hammer drill for driving screws?

I want a hammer drill because the walls of our house is concrete and I want to place small cabinets. Do hammer drills drive screws as well?

If not, so I should buy a hammer drill and an impact drill as well? Or is there a two in 1 power tool that does that?
Update: WHAT brands do you recommend? Be specific please.. THNX!
22 answers 22