First of all, this question is somewhat high level (or as I also like to call it.. Vague). I have worked in a few IT departments and every place I go I seem to see the same thing, users are looking for a way to bring there old access databases for things like IT inventory and task management onto the web. SharePoint is the obvious choice, but it seems it can get about 90% of the way there out of the box. Then all of a sudden you hit a dead end and your only option is to bust out visual studio to complete the rest, obviously not great when the end user has done the first 90% themselves ! The real restrictions seem to be on linking lists, permissions on individual list columns etc
I see SharePoint 2013 and Access 2013 can now be linked/integrated, has anybody tried this sort of stuff and is it really doable for an end user like Microsoft say ?