MS Access

Working with Forms

A form created in Access is similar to the ordinary paper forms that you fill out with a pen or pencil only you don't have to worry about trying to read poor penmanship. In Access, forms provide an easy way to enter and view data in a table. Here are just a few examples of how forms make working with data easier.

  • Easier to View and Use: Instead of scrolling back and forth in a table's datasheet, a form lets you focus on one record at a time.
  • See Data Any Way You Want: You can design forms to present information any way you like.
  • Combine Data from Linked Tables: One form can display data from several related tables or queries and your users will never know that they are working with two sources!

And that's just for starters. No doubt about it forms make your database easier to use. Just like a Windows dialog box (which is really what a form is), Access forms can include fill-in-the-blank fields, check boxes, drop-down lists, and more. This tutorial explains everything you have ever wanted to know about forms and maybe a few things you didn't want to know.