How do I connect the location of a calendar event with the iPad maps app?
Sadly, (as of iOS 4), this cannot be done. The location field of an event does not recognise an address, no matter how perfectly you enter it.

[UPDATE] In iOS 5, the location field in any calendar event will (if properly formatted) hyperlink to the Maps app.