Page 277 - Computer - 10(A&B)

• Enter at least 10 records in each table, making sure that data is consistent in all the tables.

• Create a form for each of the tables for smoother data entry.
• Create the following queries:
 query to display records of all “Premium” members.
 query to display records of all books by a specific author. (Use a name from the table)
 query to display records of members who paid a fine for returning books after the due return date.
 query to display records of all books whose price falls between 400 and 1000.
 query to display records of all books whose quantity is below 5 or price is above 500.

• Create the following reports:
 report to display the details of all members of the library.
 report to display the details of all books published by a specific publisher.
 Save all the work with suitable names.

159