How To Create A Data Entry Form In Excel - ADD, MODIFY AND DELETE!

Learn: The Quick & easy way How To Create A Data Entry Form In Excel With Add, Modify And Delete

In this video, you will learn:
1. How To Create A Data Entry Form In Excel With Add, Modify, And Delete
2. Excel Data Entry Form

In my last video tutorial, I talked about How to Use Fill Handle in Excel

In today's video tutorial, I am going to show you How to Create a Data Entry Form in Excel with Add, Modify and Delete

In excel, we have a Form command which we can use it for creating Forms in Excel. To activate the forms in excel, go to Option in the File menu, then select Forms from the Customize Ribbon menu list. The form is available under the Commands Not in Ribbon dropdown. Just select All Commands from the command form drop-down list and search for FORM. Once activated, on selecting the Form from the menu tab, you will get the custom form that will pick all the headers from the sheet as its fields.

Steps for Adding the Forms Feature in Excel

We can add the FORM in excel by customizing the ribbon. In order to add the Form to the Home tab, follow the below steps.

• Go to the File menu and Choose Option.
• Choose the Customize Ribbon.
• We will get the customized ribbon dialogue box where we can add or remove the ribbon.
• Select All Commands from the ''Command from'' and then, Search for the FORM button from the drop-down list.
• Then click on the FORM, then navigate to New Group, then click New Group to create a New Group in the HOME menu.
• After creating 'New Group 'click on 'Add 'So that FORM will be added under Main Tabs.

You can see that FORM has been added to the new group in the Home tab Main menu, as shown on my computer here.
How to Create Data Entry Forms in Excel
The creation of the data entry form in Excel is very simple and easy. Let's understand how to create a data entry form in excel with some examples.

I have got this employee template of the database here.
In order to create a proper excel data entry form, we should maintain accurate data in the table so that it will be easier for the end-user to add, view, and edit it.

Let's see how to create a normal employee data entry form in excel
Now we have created an employee database with their emp. ID, last name, first name, Dept., and their respective Emails.
Let's see now how the excel form is used to add and delete the employee record in the employee database.

Adding New Employee
Now, I am going to show you how to add a new employee record in the existing employee database. Firstly, click anywhere in the cell
• Click on the Form button on the Home Menu.
• Once we click on Form, we will get the form dialogue box pop up.
The form dialogue box contains command buttons like New, Delete, Restore, Find Prev, Find Next, Criteria, and Close.
• New: Which will add new records to the database.
• Delete: This Delete the specific records of the employee.
• Restore: it Restore the old record.
• Find Next: it finds the next record.
• Find Previous: This Find the Previous record.
• Criteria: it Displays the records based on the employee criteria.
• Close: This will close the form window.
• Scroll Bar: Where we can scroll up and down to see the record fields.

Now let's add a new EMPLOYEE record by hitting the New Command button.
• Click on the NEW command button, So that it will ask for the employee data.

• Now I am going to update the fields like EMP ID, LAST NAME, FIRST NAME, and DEPT. AND EMAIL. After the update, we can then click on the Close button to activate the update
Right now, I have updated employee records with the specified data, which will be added to the database as per date-wise order. Therefore, new employee records will be added to the database with the new employee records, and we can see the employee count has been increased to 15.


How to Delete Employee's Record in the DataBase
• Click on the selected cell.
• Click the form button so that we will get the form dialogue box
• We can see that the total number of records has been displayed as 15 of 15 records in the FORM window.
• Click on the command button to search which employee data needs to be deleted using the Find Next and Find Previous command buttons.
• Click on delete.
• Once we click on the DELETE command button, we will get the message that the Form window will confirm whether to permanently delete the data. Click OK.
After deleting the record, we will get the database where we can see that the employee count has been decreased to 14, which means that it has been deleted successfully.

……………………………………………………………………………………………………………………….
Share this video:    • How To Create A Data Entry Form In Excel -...  

For more simple and easy to follow How to videos,

Click the Link Below to subscribe:
   / @learnexcelwitht  

Join this channel to get access to perks:

   / @learnexcelwitht  

#exceldataform #dataentry #excelform

LearnexcelwithT