I have seen a few demos on how to use Google Maps API in Access, but they usually involve using a web browser control on a form to display an HTML page with the Google Maps API code in it. Unfortunately, web browser controls don't really work when placed on a report for printing.
This demo illustrates how to construct a proper URL based on geographic locations stored in an Access table and uses one method of saving the map created by the Google Static Maps API into a local image file for use in an Access report.
Please let me know if you have any questions. To learn more about Google Static Maps API, you can read the documentation here.
This demo was created using Access 2010 and tested using only Access 2010, but it should still work in 2007 and 2013.
Please report all bugs to theDBguy@gmail.com.