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.
   44   45   46   47   48   49   50   51   52   53   54