June 2017
Beginner
1296 pages
69h 23m
English
24.2 (Query Application for the books Database) Using the techniques shown in this chapter, define a complete query application for the books database. Provide the following predefined queries:
Select all authors from the Authors table.
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.
Select a specific title and list all authors for that title. Order the authors alphabetically by last name then by first name.
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 ...