Page 49 - TP_Prime_V2.2_Class8
P. 49
21 st
In the Lab Century #Technology Literacy
Skills
• Create a table using the ‘Datasheet View’.
Reg No. Name Date of Marks Grade
Submission Obtained
T/121/15 Anshu Verma 11/07/15 18 A
T/137/15 Anjali Kumari 12/07/15 20 A+ WORKING WITH ACCESS 2016
T/145/15 Deepak Kohli 14/07/15 17 B+
1. Name the table as ‘Marks Distribution’.
2. Enter atleast 3 records.
3. Sort the data on the basis of grades.
• Create a table using the ‘Design View’.
Roll No. Name Date of Birth Phone No. Place 47
A001 Manan Gupta 12/09/1987 2354667667 Delhi
A002 Ryansh Sharma 09/05/1986 3435555555 Chhattisgarh
A003 Rahul John 02/05/1990 656554432 Mumbai
1. Sort the place in decreasing order.
2. Set Roll No as the primary key.
3. Delete the record no. A002.
4. Add another record.
SDG Activity
Create a database in Access to track and analyse waste management in your
school. Input data on daily waste generated, recycled, and disposed of, then
generate reports to identify patterns and suggest ways to reduce waste,
promoting responsible consumption and production. Discuss your findings with
your class to propose sustainable practices.

