
How to Edit and Update Names in excel data entry forms

Here note down that we will delete the employee name VAMSEE KRISHNA, whose EMP ID is 1010, for our reference to check the data is deleted or not.Īfter deleting the record, we will get the below database as follows, where we can see that the employee count has been decreased to 20, which means that EMP ID 1010 has been deleted successfully. Once we click on the DELETE command button, we will get the below msg box shown below the Form window will confirm whether to permanently delete the data.Click on the command button to search which employee data needs to be deleted using the Find Next and Find Previous command button.We can see that the total number of records has been displayed as 21 of 21 records in the FORM window.Click the form button so that we will get the form dialogue box which is shown in the below screenshot.Then, follow the below steps to delete the employee records. In this example, we will see how to delete the employee’s record. Therefore, new employee records will be added to the database as shown below with new employee records, and we can see the employee count has been increased to 21. Here we have updated employee records with the specified data, which will be added to the database as per date-wise order. Update the fields like DATE, EMP ID, NAME, DESIGNATION, and KRA.Click on the NEW command button, So that it will ask for the employee data.Now let’s add a new EMPLOYEE record by hitting the New Command button. Scroll Bar: Where we can scroll up and down to see the record fields.Close: This will close the form window.

Criteria: Displays the records based on the employee criteria.Find Previous: Find the Previous record.Delete: Delete the specific records of the employee.New: Which will add new records to the database.The form dialogue box contains command buttons like New, Delete, Restore, Find Prev, Find Next, Criteria, and Close.

