You're in charge of a library, which has three patrons (listed below):
The library contains a total of four books:
Here's the data that the librarian has:
What you need to do (the exam is open-book):
1. Create a database to store this data. (3 x 5 = 15 points). Note that:
3. Create the following forms. (2 x 15 = 30 points)
Report the book ratings by book and patron. For each book list all the patrons and their ratings. Use report wizard on the table or query of your choice. At the end of a section listing patron ratings for a particular book provide the max, min, and the average rating for that book. Save the report as Book Ratings, Patron by Patron.5. Create the following switchboard to help us grade the exam. (10 points)
From the main switchboard have five items: view tables, view queries, view forms, view report, exit application. Each takes us to a new switchboard. All switchboards take you back to the main switchboard, except the view report one, which has two options: return to main switchboard, and view report.
PRACTICAL. Points add up to 95 (highest A). For more contribute your creativity.
URL for this page: