Deleting Records
One of the veterinarians will not be available for the zoo anymore and the zoo authorities want to have his records deleted from the database.
To delete the record:
1.Open the "ZooDB" project created previously and double-click the 
ZooDBConnect data source to connect to it.
2.In the Online Browser, right-click the tblVeterinarians table and select Edit Data from the context menu. Alternatively, select the table and press Ctrl+Alt+E.
3.Click somewhere into the sixth row of the result grid and then click the Delete row 
button. The background color of the row as well as the text color change to indicate that this row is to be deleted from the database.
The row is now marked for deletion but not actually deleted in the database. If you change your mind about deleting the record, click Undo all changes 
to discard all changes from the grid.
4.Click the 
button. The row is removed from the result grid and deleted from the database.