title: What is the best way to work with Access and SharePoint?
body: <p>I'm a contractor currently working with the DOD. I work primarily with VBA and Microsoft Office (2013) to produce "Desktop Tools" because this is the level of scope in the culture here.  Rarely are the clients accessing their products from a fully integrated system that connects all of their data. One reason for this are the many disparate systems that require username and password to get and collect data.  So office products like MS Access, Excel and PowerPoint are the meat and potatoes of their reporting and dashboards.  There has been a second life to a career using only VBA which I thought was long gone.  My facility uses SharePoint 2010 and often want to see their products, like a "Desktop Access database with user security implemented" - on SharePoint. We often turn to PowerPoint to meet that need, but it is not as robust and requires a lot of manual intervention, and since many of the front end interfaces that I have built have complex form validation as well as comprehensive report views it seems to leave a lot to be considered. </p>
  
  <p>I've only worked with Visual Studio between 2005 - 2009 and I know a lot has changed.  I know SharePoint has also evolved extensively.  </p>
  
  <p>I have also heard about InfoPath, but read that I need Visual Studio if I want true control especially with data input. I have also considered the Web App component in MS Access but have many security limitations on that side that I have never considered going through with them.  What are my options with SharePoint 2010 and Desktop MS Access that have all the bells and whistles available to me in VBA if I don't have access to Visual Studio or anything else besides VBA?      </p>