Page 61 - TP_Prime_V2.2_Class8
P. 61
21 st
In the Lab Century #Technology Literacy
Skills
• Create a table for the Library Management System.
59 MORE ON ACCESS
• Create a table for the Student‘s Details.
1. Show the relationship between the two tables based upon the common field.
2. Create a form for the Student’s Details table. Enter the following records through
the form:
Gyan Shanker 8 B
Richa Sinha 6 A
3. Write a query to find the Book Name, Publication, Student’s Name, Class and Price
from both the Student’s Details table and Library Management System tables.
4. Generate a report of the query created.

