Summary

This chapter has taken on the major topic of building select queries. Without a doubt, query creation is a daunting task, and one that takes a lot of practice. Even simple queries can return unexpected results, depending on the criteria used to filter data in the underlying tables.

Queries are an integral and important part of any Access database application. Queries drive forms, reports, and many other aspects of Access applications.

Your best bet for mastering Access queries is to try increasingly difficult queries, and to always check your work. In the case of improperly joined tables, Access queries almost always under-report the data in the tables. You will discover the missing records only by carefully examining the data to ensure that your query is working properly.