Access Data Input Via Forms

Part 8: Access Data Input Form

Customers Form
Customers Form.

Note: This article is one of a series on  "Building an Access Database From the Ground Up."  For background, see Creating Relationships , which sets up the basic scenario for the Patricks Widgets database discussed in this tutorial.

Now that we’ve created the relational model, tables and relationships for the Patricks Widgets database, we’re off to a great start. At this point, you have a fully functional database, so let's start adding the bells and whistles that make it user-friendly.

Our first step is to improve the data entry process. If you’ve been experimenting with Microsoft Access as we’ve built the database, you have probably noticed that you can add data to the tables in the datasheet view by simply clicking ​in the blank row at the bottom of the table and entering data that complies with any table constraints. This process certainly allows you to populate your database, but it’s not very intuitive or easy. Imagine asking a salesperson to go through this process every time she signed up a new client.

Fortunately, Access provides a much more user-friendly data entry technique through the use of forms. If you recall from the Patricks Widgets scenario, one of our requirements was to create forms that allow the sales team to add, modify and view information in the database. We’ll begin by creating a simple form that allows us to work with the Customers table. Here’s the step-by-step process:

  1. Open the Patricks Widgets database.
  2. Choose the Forms tab on the database menu.
  3. Double-click “Create form by using wizard.”
  4. Use the “>>” button to select all fields in the table.
  5. Click the Next button to continue.
  6. Choose the form layout that you’d like. Justified is a good, attractive starting point, but each layout has its pros and cons. Pick the most appropriate layout for your environment. Remember, this is just a starting point, and you may modify the actual form appearance later in the process.
  1. Click the Next button to continue.
  2. Choose a style, and click the Next button to continue.
  3. Give the form a title, and then choose the appropriate radio button to either open the form in data entry mode or layout mode. Click the Finish button to generate your form.

Once you’ve created the form, you may interact with it as you wish. The layout view allows you to customize the appearance of specific fields and the form itself. The data entry view allows you to interact with the form. Use the “>” and “<” buttons to move forward and backward through the recordset while the “>*” button automatically creates a new record at the end of the current recordset.

Now that you’ve created this first form, you're ready to create forms to assist with the data entry for the remaining tables in the database.

mla apa chicago
Your Citation
Chapple, Mike. "Access Data Input Via Forms." ThoughtCo, Nov. 20, 2016, Chapple, Mike. (2016, November 20). Access Data Input Via Forms. Retrieved from Chapple, Mike. "Access Data Input Via Forms." ThoughtCo. (accessed January 20, 2018).