Updating databases

You have done a great job so far, but now we will actually start editing the data in our databases. You will learn how to execute the following types of SQL statements:

• Insert
• Update
• Delete

When working with databases, understanding how to update specific records, delete specific records, and append new records is essential. For the walk-throughs, we will continue working with the sample Access database. Instead of creating a connection for each statement type, it makes sense to just connect once for all of them as we're using the same database. We will begin by building the initial skeleton using the Step action.

Let's start this walk-through by performing the following steps:

1. Add a Step just below line 20, set the Title property as Updating to Databases, and then click on Save.
2. Again, we will add our connection to the Access database, dragging the Database: Connect action just below line 21, ensuring it is within...