The door barrel and key is mechanical and will not be effected by a flat battery.
To get under the hood, if your car is RHD, get in behind the R/H arch liner ( at the top close to the arch) and fish out the bonnet pull cable and gently give it a tug, you will be pulling the inner and outer cable so expect some resistance.