Chapter 7. Retrieving Data with Queries

In this chapter

  • Using the Query Wizard

  • Working with data in queries

  • Building queries in design view

By now, you should be comfortable with putting your data into Access tables. You know how to create a table and how to work with the data directly in a table. You’ve seen, too, how you can use relationships to tell Access how the data in more than one table is linked together.

But tables and relationships are just the first steps in building a truly useful Access database. You can think of these objects as the foundation of your database. They’re essential, and you have to put them in place before anything else. But after the foundation is in place, you can build atop it. In this chapter, you’ll start building ...

Get Absolute Beginner’s Guide to Microsoft® Office Access 2003 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.