Microsoft Office® Access 2007 Inside Out

Simplifying Data Input with a Form

One drawback to working with a relational database is that often you have to deal with information stored in multiple tables. That’s not a problem if you’re using a query to link data, but working with multiple tables can be confusing if you’re entering new data. Access 2007 provides some great ways to show information from related tables, thus making data input much simpler.

Taking Advantage of Combo Boxes and List Boxes

In Chapter 10, you saw how you can use a combo box or a list box to present a list of potential values for a control. To create the list, you can type the values in the Row Source property box of the control. You can also specify a table or a query as the source of the values in the list. Access ...