Entering data and updating forms
Click the buttons in the interactive below to learn about a simple form.
The drop-down search box allows you to search for existing records.
Throughout this tutorial, we will be using a sample database.
If you would like to follow along, you'll need to download our Access 2016 sample database.
Note The feedback system for this content will be changing soon. If content within a comment thread is important to you, please save a copy.
Finally, you will learn how to use forms to enter new records and view and edit existing ones.The records in these tables include ID numbers of records from other tables.You can't learn much just by glancing at these records because the ID numbers don't tell you much about the data they relate to.Plus, because you have to look at two tables just to view one order, you might have a difficult time even finding the right data.It's easy to see how viewing or entering many records this way could become a difficult and tedious task.Not only do forms make the data entry process easier for the user, but they also keep the database itself working smoothly.With forms, database designers can control exactly how users are able to interact with the database.When you're using a form, you don't have to worry about entering data into the right tables or in the right format—the form can handle these things itself.There's no need to go back and forth between tables because forms bring all of the information you need together in one place.They can even set restrictions on individual form components to ensure all of the needed data is entered and that it's all entered in a valid format.This is useful because keeping data consistent and organized is essential for an accurate and powerful database.