Access 2010: The Missing Manual

Chapter 13. Designing Advanced Forms

As you learned in the previous chapter, forms can streamline day-to-day tasks and even give your database a sharp, distinctive look. To be a master database builder, you need to be able to craft top-notch forms.

In this chapter, you’ll take form building to the next level with a whole new arsenal of techniques. First, you’ll learn how to create a form in the no-holds-barred Design view, where you can tweak and polish every square inch of your form. Then, you’ll take a tour of Access’s different controls, and jazz up your form with links, tabbed panels, and buttons. You’ll also learn how to work with linked tables by creating special types of forms called subforms that work in harmony with other forms.

Customizing Forms in Design View

In the previous chapter, you learned how to quickly create different forms using the ribbon’s buttons and the Form wizard. But serious form gurus take a different approach—they build a form by hand. There are two ways you go about this task:

• Create a form in Layout view. Choose Create→Forms→Blank Form. Then, drag the fields you want from the Field List pane onto your form (Figure 13-1). You learned everything you need to pull this off in Chapter 12. You can quickly create a standard form with a stacked or tabular layout, but it doesn’t give you any extra frills.

• Create a form in Design view. Choose Create→Forms→Form Design. Now you’ll start with a blank form in the design window. You can drag fields onto your form from ...