I have a program/database that was originally stored locally for a client and ran completely in Access 2010. It was then put up on the cloud (azure) with the help of an outside source. My problem is this, when it was completely in Access 2010 I could work with it because I know Access and VBA. Now that it has been moved to the cloud I have to do queries and such in SQL, he converted much of my work to stored procedures, and incorporated modules.
For most of you these things would seem like a great step, but for me, it is like another language and it has really impacted what I can do when I modify the program (I feel like I am trying to debug French when I only understand English).
My question is: Is it possible to move only the tables onto the cloud and then give every user the Access program (runtime version) which would contain everything BUT the tables? Basically I want to be able to use Access to create queries, reports and such without having to really know SQL. I know this would probably be a step backwards, but I was wondering if it could work. This way I could understand my own program again.