Page 110 - TP_iPlus_V2.1_Class7
P. 110

#Experiential Learning
                     Let’s Explore


                            Examine  the  three  types  of  relationships  that  can  be  established  between  tables  in
                            MS Access.




                                                                                            #Digital Literacy
                                                                                            #Creativity & Innovativeness


                         Practical Time


                      For a school database, create the following two tables:
                         Student                                     Fees
                         Stud_admno                                  Stud_admno
                         Stud_Name                                   Stud_Name
                         Stud_class                                  Stud_stream
                         Stud_section                                Stud_fees
                         Stud_dob

                        1.  Establish the relationship between the two tables.
                        2.  Create two forms: one for the Student table and another for the Fees table.

                        3.  Enter five records in each table using the above created forms.
                        4.  Use a query to display the student name, class, and fees, sorted in descending order by fees.





                      Teacher’s Corner

                  1.  Discuss how to create a report using data from multiple tables.
                  2.  Describe the concept of a primary key and a foreign key, and provide examples.
                  3.  Explain the various search criteria options available in queries.


























                   108
                         iPlus (Ver. 2.1)-VII
   105   106   107   108   109   110   111   112   113   114   115