I know this question is old but there is still not much info on how to do it. I've just spent a few hours working it out.
Use a Web Browser Control on your Access form. Then set the Control Source to (for example, using a text box on my form called txtTotalShops and a field called Address1)
="https://maps.googleapis.com/maps/api/staticmap&zoom=7&size=600x300&maptype=roadmap&markers=color:orange%7Clabel:" & [txtTotalShops] & "%7C" & Replace([Address1]," ","+") & ",NSW,Australia&key=AAAAAAAA"
You can change the zoom, size, markers etc as you wish (Note that the marker properties need
%7C between them, other properties just an ampersand). Any spaces must be replaced with a plus sign (as in the example for Address1)
You can have up to 15 markers if you are using a human readable address (or unlimited if you use latitude and longitude)
AAAAA needs to be replaced with your own Google API key (free for 25,000 map loads per day)
If the whole statement becomes too long for Access, split it into several hidden text boxes on your form and then concatenate them (
=txtWebAddress1 & txtWebAddress2 & txtWebAddress3) etc.
Full documentation (and instructions to get your API key) at https://developers.google.com/maps/documentation/static-maps/intro#Markers