This chapter covered various aspects including opening the query generator, choosing tables, entering column criteria, sorting and showing columns, and altering the number of criteria rows or columns. We also learnt how to use the AND and OR operators to define relations between the rows and columns, and how to use automatic joins between tables. The Designer-integrated visual query builder was covered as well.

The next chapter will show you how to synchronize data between servers and how to manage replication.