I am trying to design a small database project for school. I have gone over this for about a gazillion time, and it seems to have turned into a challenging maze. This is from the book "Visual Basic 6 How to Program." Anyway, where is the problem:
Define a complete query application for the Biblio.mdb database that comes with Visual Basic compiler. The user should be able to edit existing data and add new data to the database. Provide a series of predefined queries with an appropriate name for each query displayed in a Command Button or List Box. Provide the following predefine Queries:
A. Select ALL authors from the Authors table.
B. Select ALL publishers from the Publishers table.
C. Select a specific author and list ALL books published by that publisher. Include the title, year and ISBN number.
Order the information alphabetically by title.
D. Select a specific publisher and list ALL books published by that publisher. Include the title, year and ISBN number. Order the information alphabetically by title.
E. Select a publisher and display its address, phone number and fax number.
For each of the preceding queries, the results should be displayed in a GRIDBOX Control.
Your program should allow the user to UPDATE fields, DELETE records, FIND records by a given field and ADD records to the database.