Page 99 - iPro_trackGPT_V5_Class7
P. 99

5  Click on the Create button.




                     4  Drag and drop
                     the Primary Key field
                     of one table to the
                     common field in the
                     another table.




                 This will create a line or relationship between 'Student's Detail' table and 'Fee' 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.








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













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




                                                                                               More on Access    97
   94   95   96   97   98   99   100   101   102   103   104