Excel 2003 Data Entry Form

Opening the Data Entry Form

Note: For help with this example, see the image above.

1. Click on cell A2 to make it the active cell.


2. Click on Data > Form in the menus.


3. Opening the form will first bring up a message box from Excel containing a number of options related to adding headings to the form.


4. Since we have already typed in the field names we want to use as headings all we have to do is Click OK in the message box.


5. The form containing all of the field names should appear on the screen.

• Using a Form for Data Entry in Excel
• Adding the Database Field Names
• Opening the Data Entry Form
• Adding Data Records with the Form
• Adding Data Records with the Form (con't)
• Using the Form's Data Tools
• Searching for Records Using One Field Name
• Searching for Records Using Multiple Field Names