Page 105 - TP_iPlus_V2.1_Class7
P. 105

5  Drag and drop the Primary Key field of one
                         table to the common field in the another table.         6  Click on the Create button.














                 This will create a line or relationship between 'StudentsDetail' table and 'StudentsMarks' table
                 based on the Primary Key named ‘Roll No’.











                                                                                          Relationship
                                                                                          established.





                 Creating a Query


                 To create a query, follow the given steps:

                            1  Click on the
                           Create tab.         2  Click on the Query Design command on the Queries group.











                                3  Select the desired table and click on the Add button.















                      4  Double click to add the field's name to the query window.   5  Specify the criteria.





                                                                                                                 103
                                                                                                More on Access
   100   101   102   103   104   105   106   107   108   109   110