Goal: Gain experience using Microsoft Access database software.
At the end of every semester, students put up posters around campus listing what used books they have for sale. You have been asked to create a database where students can list the books they want to sell and other students can look up a particular class and see if anyone is selling books for that class.
Decide what data you will need to store in the database and how the data is organized into tables. I would suggest you keep it simple. Try to determine what data fields are really needed and limit the number of tables to 2 or 3.
Then create the actual tables in Access. Enter some sample data into the table. Finally, create two forms. The first form should be the "Main Menu" which contain buttons to open up other forms (for now we will only create one other form). The second form should be the "Book Listing Form" which would allow a student to enter her/his information and the details about the book. Next week we will add a form that will allow a student to enter a course and see what books are available for that course.
You will need to demonstrate this lab to the instructor. Also, make sure you do a write-up as you complete the lab.