I'm in charge of creating a table that filterable in a SharePoint environment. I understand access can work with SharePoint as a linked table. But I don’t want to start this task until I’m sure it's the best approach moving forward.
I would want to the user to be able to view the table without having Access installed on each users' workstation; web accessible. I understand Access web services can accomplish this task.
I've also come across suggestions to use Excel table with auto-filters. Would this be a better option?
Ultimately I want to be able to automate sending report/ tables via email. I'm looking for a suggestion on how to design and reference doc to support how to accomplish that suggestion.