OK I know its 5 pages back now and I am a bit new here on the forums, however in regards to the original post...
There is a macro language called AutoHotKey that I have used to create custom screens that can read and write data into and out of the AC app. It does it using the interface (no database access though I was tempted).
It can be as advance or simple as you like. I made one for a pain clinic that walks them through the appointment asking the questions they fill in the answers with drop downs and clicks and it creates the text. Or you can create short abbreviations that will automatically turn into longer text.
