With a proper concrete drill bit, even an electric drill without impact function can and will drill a hole through concrete - the only difference is that it will take significantly longer to drill a hole (as can be seen in this video).

Additionally, you're also limited by the size of the drill chuck to either 6mm, 10mm or 13mm which corresponds to the size of the drill bits you can use - the diameter of the drill bit will also determine the final size of the hole in the wall.

If you can only have one tool and you are mainly working with concrete with the occasional need to drill smaller holes in softer materials, a rotary hammer drills (which typically have an SDS or SDS Plus chuck that will accept bigger bits without slipping or vibrating loose) can equally function as a drill and use existing drill bits with an optional SDS or SDS Plus three-jaw chuck.