Handguns did the job on Ronald Reagan and almost for Gerald Ford.
Leaving Abe Lincoln to one side, but if you are lucky and your security detail is a bit lax, a handgun can get the job done. I'm Australian, so we don't see much of that sort of thing.
You seem to be implying that handguns don't count even though it has happened, or actual attempts, multiple times. Ok...?