Using the techniques shown in this chapter, define a complete query application for the books database. Provide the following predefined queries:

a) Select all authors from the Authors table.

b) Select a specific author and list all books for that author. Include each book’s title, year and ISBN. Order the information alphabetically by the author’s last name, then by first name.

c) Select a specific title and list all authors for that title. Order the authors alphabetically by last name then by first name.

d) Provide any other queries you feel are appropriate. Display a ComboBox with appropriate names for each predefined query. Also allow users to supply their own queries. A ComboBox is similar to a ListView, but displays its items in a drop-down list.