Databases and data storage have become necessary tools for most organizations. The challenge is figuring out the best way to use this data. While data can be manipulated manually using spreadsheets, crafting an effective form can greatly reduce the need for manual manipulation. It can also provide a single point of access for data inquiries and eliminate double entry processes. Microsoft Access is a popular tool for creating effective data entry forms that can also be pulled into Microsoft Excel or most any other spreadsheet application. The following will show you how to build a data entry form in Access.
Click on the "Forms" button on the left-hand of the screen. Use the Form Wizard for an automated guide through the data entry form creation.
Follow the Wizard instructions. When the Wizard asks you which fields you would like to use, either input the fields you would like or use the suggestions. For the purposes of this tutorial select "All." Use the double arrow (>>) to perform this action in one step.
Choose a layout. You can experiment with several different layouts within the Wizard to see which one is best suited for your needs. The most basic layout is Columnar. Choose "Columnar" and select "Next."
Choose the style you would like your form to be in and the title. Select "Standard" and title your form with a relevant name. For this example, use Client Contacts.
Choose "Open the form to view or enter information." This is the last screen. Select the "Finish" button.
Add records by using the buttons at the bottom of the table. To customize the form go to Design View by clicking on "View" at the upper left-hand side of the screen. Use controls like text boxes, labels, and combo boxes to provide the user with predefined information about the kind of data needed for input into the form. If you don't see the Toolbox, click on "View" and select "Toolbox." When finished, the form will automatically save. See Resources for Access data entry form templates.