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.

This article has been dead for over six months. Start a new discussion instead.