Using Excel as a database
Excel has many of the features we would commonly associate with Access. One feature that may be helpful for data entry is using Excel's data form feature. Here's how it works:
Once this basic setup is complete, you can start entering and managing records with the Data menu's Form tool. When you open this dialog box, you'll see that Excel has set up data-entry boxes labeled with your column headings. To enter a new record, click the New button and start filling in the fields. When you finish a field, press TAB to move to the next field rather than ENTER. Pressing ENTER tells Excel you're finished with that record and creates a new one before you're ready. When you're really finished with a record, press ENTER or click the Close button.
« Back to the Technology FAQ & Tips page