To edit the data within the table click on the record you wish to edit in the connection preview and make the required change. Once you are done either hit return or click off of the record.
This will run an update query, which can be seen in the output window.