You learned the basics of query design in Chapter 4, "What Every Developer Needs to Know About Query Basics," but Access has a wealth of query capabilities. In addition to the relatively simple Select queries covered in Chapter 4, you can create Crosstab queries, Union queries, Self-Join queries, and many other complex selection queries. You can also easily build Access queries that modify information, rather than retrieve it. This chapter covers these topics and the more advanced aspects of query design.