Chapter 7. Working with Forms

CHAPTER TASK: CREATE AND WORK WITH SEVERAL TYPES OF FORMS

Prerequisites

• How to use menus, toolbars, dialog boxes, and shortcut keystrokes.

• How to open and modify database objects.

• How to add and edit database records.

A form created in Access is similar to the ordinary paper forms that you fill out with a pen or pencilonly 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 queriesand your users will never know that they are working with two sources!

And that's just for starters. No doubt about itforms 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 chapter explains everything you have ever wanted to know about formsand maybe a few things you didn't want to know.