O'Reilly logo

2007 Microsoft® Office System Step by Step, Second Edition by Joan Lambert, John Pierce, Steve Lambert, M. Dow Lambert III, Curtis D. Frye, Joyce Cox

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Creating a Query by Using a Wizard

The process of creating a simple select query by using the Query wizard is almost identical to that of creating a form by using the Form wizard. Within the Query wizard, you can build a new query based on one or more fields from existing tables or queries. You can also create Crosstab, Find Duplicates, and Find Unmatched queries with the wizard.

For Access to work effectively with multiple tables, it must understand the relationships between the fields in those tables.

See Also

For more information about creating relationships, see the sidebar Relationships in Chapter 10.

In this exercise, you will use the Query wizard to create a query that combines information from two tables related through common fields.

Note ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required