Not all Microsoft Access forms are made for data entry. Some
forms are made for data search and analysis, which can contain features such as
option groups, check boxes, and combo boxes.
Forms made for quick data entry of large volumes of records
should be built without such controls. Rather, they should consist of a simple
top-to-bottom layout, with all of the controls lined up in a single column.
To create a simple data entry form, follow these steps:
- In the
Database Window, select the table for data entry.
the New Object tool in the Database toolbar.
Form, select Design View, and click OK.
the Field list button in the Database toolbar.
[Ctrl] and select the fields to be added to the form.
and drag the selected fields to the form.
Be sure to set the form’s Cycle property to All Records so
that tabbing out of the last field takes the user immediately to a new record.
Help users increase productivity by automatically signing up for TechRepublic’s free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.
Subscribe to the Data Insider Newsletter
Learn the latest news and best practices about data science, big data analytics, artificial intelligence, data security, and more. Delivered Mondays and Thursdays