Page 109 - iPlus_Ver_2.0_class_7
P. 109
#Digital Literacy
#Creativity & Innovativeness
Practical Time
Create a table for the Library Management System.
Create a table for the Student‘s Details.
• Show the relationship between the two tables based upon the common field.
• Create a form for the Student’s Details table. Enter the following records through the form:
Gyan Shanker 8 B
Richa Sinha 6 A
• 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.
Teacher’s Corner
1. Make the concepts of Query, Form, and Report clear and the difference between these to the students.
2. Demonstrate how forms and reports can be customised.
3. Explain different types of queries to the students.
107
More on Access

