Fiction Bookstore Db Solution
Jerry Schmidt, the manager of the Fiction Bookstore, uses a Microsoft Access database named Books to keep track of the books in his store (see above). The database has one table named tblBooks. The table has five fields. The BookNumber, Price, and QuantityInStock fields are numeric. The Title and Author fields contain text. Mr. Schmidt wants an application that he can use to enter an author's name (or part of a name) and then display only the titles of books written by the author. Display the information in a DataGridView control; however, don't allow the user to add, delete, edit, or save records. In this application, you need to allow the user to specify the records he wants to select. He will use the button to tell the computer to display the selected records. Mr. Schmidt also wants to display the total value of the books in his store. Save the solution and then start the application. Click the Exit button and then close the solution.
You'll get 1 file (205.1KB)