Contributing to an Access Database with RPA
In the previous chapter, we covered some of the capabilities of robotic process automation—including use cases and some general best practices.
But what better way to understand it than to actually do it?
To do that, we’re going to take input from a Microsoft Forms survey. In Chapter 14, Working with Microsoft Forms, you took user-submitted data and inserted it into a SQL database. In this chapter, we’re going to take that Forms data and then enter it into a Microsoft Access database using a desktop flow.
The topics we’ll cover in this chapter are as follows:
- Configuring prerequisites
- Configuring an RPA flow
- Testing the flow
- Verifying the flow
By the end of this chapter, you should walk away with an understanding of some of the capabilities of the Power Automate Desktop environment.
Let’s go!
