Ps4 – Transfering ps3 psn account to ps4

I am not sure about Madden 11 per say and the access code that is required.

But if you go to Playstation Network > Account Management > Transaction Management > Download List you will see all the games/maps/dlcs etc that you have downloaded.

You can download them again on up to 5 ( can't find sources ) different PS3 systems and you can re-download them as many times as you want on the same system.

You should activate your ps3 and check this out.

Yes. As long as you've "activated" your console with the secondary account, you may use the games and DLC bought in it by different users on the same console.

There may be some exceptions to this (I know of a single game and a couple of DLC), but to be on the safe side, on the store's product page, look for the disclaimer

One time fee for use of downloads on up to 2 activated compatible Home Console systems.

For comparison, here's what the disclaimer on a "single user" game looks like:

One time fee for use of downloads solely by the purchasing Sony Entertainment Network account on up to 2 activated compatible Home Console systems. No more than 1 activated compatible Home Console system within a 24 hour period. Content may not be used by any other account. You must sign in to PSN each time you start the game.

(Emphasis mine)