It's not as bad as it sounds Maryrrf. But if you are useed to driving an automatic, make sure you get an automatic to drive, because it's a very different way of driving, anmd you'll have enough on your plate with the road signs and all. (In fact in England a driving test on an automatic doesn't qualify you to drive a manual car - I had to take another test when I changed over a few years ago, and it wasn't easy.)
Automatics tend to be what we'd call bigger cars, but that means small to medium cars for Americans.
Have a great time.