Since you are an Advanced Excel User, you may have someone other than yourself who frequently adds records to databases or tables that you have created. If this is the case, you should definitely encourage the use of the Data Form Tool. For anyone who routinely enters data, it can make 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. Presto, there is is! 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!
No comments:
Post a Comment