Sorry it didn't go too well for you the first time through. I remember back when I took mine I was used to driving manuals already (drove them since I was about 12-13), but used my aunt's automatic to make things easier. (I was in a town I didn't really know.) My worst setback was I had broken both bones in my arm a couple days before my tentative test (enduro accident, an off-road/on-road motorcycle) and had to cancel until I could use both hands again.
Hope things go well for you the next time around.
And for the record, I will only drive a manual. (aside from my original auto Challenger) Autos get too boring just hitting the brake and gas.