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.
To modify data:
Do one of the following:
To modify existing data, tab to a field and enter a new value.
To add a row, select Insert Row from the pop-up menu and enter data in the new row.
To delete a row, select Delete Row from the pop-up menu.
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.
Select Save from the pop-up menu to apply changes to the database.