adding on the the recent JSON presentations, this shows an Access application you can download to try for yourself and how to read AND write using a web API
AL: Get and Post with JSON using Microsoft Access and VBA by Neil Sargent (+Leo @theDBguy) (28:42)