You can add, modify, or delete rows. When you have finished manipulating the data, you can apply the changes to the database.
If looking at data from a view
Some views are logically updatable and others are not. Some
DBMSs do not allow any updating of views.
For the rules your DBMS follows regarding updating of views, see your DBMS documentation.
Do one of the following:
To modify existing data, tab to a field and enter a new value.
To add a row, click the Insert Row button and enter data in the new row.
To delete a row, click the Delete Row button.
When you add or modify data, the data uses the validation rules, display formats, and edit styles that you or others have defined for the table in the Database painter.
Click the Save Changes button or select Rows>Update to apply changes to the database.
To modify data: