Forum Discussion
paola1475
Jan 05, 2020Copper Contributor
Creating an Automated Process
Hello, I am trying to create an automated process using Access that can be integrated with SharePoint. I would like to make a sort of wizard that guides users through the process. Is that possible? ...
George_Hepworth
Silver Contributor
You can use SharePoint Lists as tables in an Access Relational Database Application, yes. And, on the SharePoint side I'm sure there are ways to automate certain actions as Workflows. (I don't have much experience there.)
That said, if the automation happens in SP, and the data is stored in SP lists, the data can be exposed in Access, and that means you can do additional processing from the Access side, using typical Access features and functions.
Again, it's kind of a large project, and potentially fairly challenging. If you can implement it, it ought to be pretty impressive.
paola1475
Jan 06, 2020Copper Contributor
George_Hepworth thank you so much for your advice! Hopefully this works as it is the best solution for this specific process.