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)
Classes eloquently and simply explained by Anders (theSmileyCoder) for Access Europe hosted by Colin @isladogs
AEU38: Using Class Modules in the Real World (Anders Ebro)
57:08
download the presentation incuded the elegant example database, and read the decription on Colin's site here: Class Modules: How, Why and When To Use Them in the Real World (Anders Ebro) https://www.isladogs.co.uk/aeu-38/