Microsoft Access forms made for quick data entry of large volumes of records should consist of a simple top-to-bottom layout. Get step-by-step instructions on how to create a simple data entry form.

Although you could store even complex data in list form in Excel, doing so typically results in a lot of data duplication and the risk of data-entry errors.

Access allows you to prevent users from inadvertently changing data on their forms. Here's how to set the control properties called Enable and Locked to prevent data entry.