Absolute Beginner's Guide to MicrosoftR Access 2002

In this chapter, you learned about working with queries. After using tables to save data in your database, you can use queries to get the data back out:

• Queries provide a flexible way to display data from a database. You can combine data from multiple tables or display only the data of interest by using queries.

• The Simple Query Wizard provides a quick way to build up queries that return records from one or more tables.

• Query design view is a more flexible alternative to the Simple Query Wizard. With query design view, you can control the sorting order of the displayed records and set up complex filters to limit the amount of data returned by a query.