If you or someone you work with frequently adds records to databases or tables, you should definitely give the Data Form Tool a try. For anyone who routinely enters data, it can make your life a bit easier.
How to Add the Form to Your Workbook for Excel 2007 & 2010 Users:
1. Click the down-arrow of the Quick Access Toolbar in the upper-left corner of your workbook
2. Choose Customize Quick Access Toolbar
3. Select All Commands and choose Form…
4. Click the Add>> button and click OK
Now go to your database or table and select the Form from your Quick Access Toolbar. Suddenly… Bam! Up pops a New Data Entry Form for updating your database!
Just tab through the Form as you enter your data, and watch your table or database update as you do. Wow, what a Great Little Tool! Give it a try!