Page 104 - iPro_trackGPT_V5_Class7
P. 104
Code Clues #Experiential Learning
#Problem Solving & Logical Reasoning
Locate eight terms related to Access in the following grid:
R E P O R T S N T M
E F Z Y U B L P F R
C S H L I L T A O B
O V Z D X A Q G R Y
R Q U E R Y H E M L
D K D S G O H S Y M
S J K I R U B E I T
I P Y G M T I T L E
L O C N Z I Y U K Q
Z P Q M W O N P X E
SDG Activity
Use Microsoft Access to track and analyse the consumption and
management of school resources, promoting responsible usage and
sustainability.
Digital Drills #Digital Literacy
#Creativity & Innovativeness
Create a table for Student Fee System.
Create a table for Student Clubs and activities
Create a table for Student details
Create a relationship between three tables using the common fields.
Create a form for Student Clubs and activities and enter the following details:
• Avni Singh VII C Horse Riding Rs. 1500
• Aman Gupta IX B Football Rs. 1450
• Ananya Aggarwal VIII D Painting Rs. 1200
Write a query to find total fee of students studying in class VIII D
Generate a report of the query created.
Teachers' Turf
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.
102 TrackGPT iPRO (V5.0)-VII

