Page 55 - TP_Prime_V2.2_Class8
P. 55

To create a relationship, create two tables:
                 •  Table named ‘StudentsDetail’ that holds general information about the students such as

                   their Roll No, Student's Name, Father’s Name and Class.

                 •  Table named ‘StudentsMarks’ that holds information about Roll No, Marks and Percentage.











                                                 Using Tables for Defining Relationships                                    MORE ON ACCESS

                 To define relationship between the two tables, follow these steps:

                 Step 1:  Click on the Relationships command
                           from  Relationships  group  under

                           Database Tools tab.                                                                            53

                 Step 2:  The Show Table dialog box will open.
                           Click on the Add button. The selected
                           table  will  appear  in  the  relationship                 Database Tools tab

                           window.  After  adding  the  desired
                           tables,  click  on  the  Close  button  to

                           close the Show Table dialog box.
                 Step 3:  Click  and  hold  on  the  Primary Key

                           field of one table.

                 Step 4:  Drag  the  mouse  pointer  to  the
                           common field in the other table and
                           release the mouse button. This will

                           open Edit Relationships dialog box.
                                                                                 Edit Relationships Dialog Box
                 Step 5:  Click on the Create button.
                 This will create a line or relationship between the related fields of the two tables:






                                                                      Relationship established between
                                                                      'StudentsDetail' table and 'StudentsMarks'
                                                                      table based on the Primary Key named ‘Roll No’.



                                  Relationship Created
   50   51   52   53   54   55   56   57   58   59   60