Microsoft Office Tutorials and References
In Depth Information
Chapter 1: Designing Custom Forms (and Reports)
Chapter 1: Designing Custom
Forms (and Reports)
In This Chapter
Understanding and using forms
Creating a form with a wizard (the easy way)
Using your new form to enter and edit records
Creating or modifying a form in Layout view
Changing the properties of a form
Saving, copying, printing, importing, and renaming your forms
Although datasheets are convenient for looking at, entering, and
editing the information in tables and queries, there’s a lot to dislike about
them as well. Datasheets show records one per row, and if your table or
query has a lot of fields, you need to scroll left and right to see all the fields.
Also, datasheets rarely look anything like the paper forms that your
information may be coming from. Finally, datasheets display information from only
one table or query at a time, even though when you enter or edit data, you
may need to make changes in related tables at the same time.
Forms to the rescue! When you design your own forms to display
information onscreen, you choose where fields appear, what explanatory text
appears, and what lines and boxes to add. Your forms can include
calculations, such as the total number of items that a customer is ordering. You
can also include subforms, which are small forms that display information
(usually, more than one record’s worth) from a related table or query. You
can also make forms that contain buttons that run programs (Visual Basic
for Applications [VBA] modules), open other forms, print reports, or exit
Access — your own Mission Control.
After you design a form (a first draft, anyway), you can save the form design
as part of your database and use it any time to view the table or query with
which the form is associated. You can always change the design of a form
later; no one makes a perfect form the first time.
This chapter describes how to make simple forms (by using a wizard or by
creating them from scratch) and how to rearrange the fields on a form in
Layout view.
Search JabSto ::




Custom Search