Page 44 - Touchpad_Plus_V3.2_Class 8
P. 44

Tools menu

                  Step 2  Select  the  table    and  click  on  the  Add  button.  The
                           selected  table  will  appear  in  the  Relation Design
                           window.  Repeat  clicking  Add  button  to  add  more
                           tables in the Relation Design window. When all the
                           required tables have been added, click on the Close
                           button.

                  Step 3  Press and hold the left mouse button on the Primary
                                                                                                   Add table
                           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  create  a  line  or  relationship  between  the
                           related fields of the two tables.
                           Relationship  established  between  Student  table  and
                           Fee table based on the field named ‘Roll No’.
                  Creating a Query                                                            Relationship Created

                  To create a query, follow these steps:

                  Step 1  Click on the Queries button in Database pane.
                  Step 2  Click on the Create Query in Design View option in Tasks pane. The Add Table or
                           Query dialog box will open.
                  Step 3  Select the tables to be added and click on the Add button.





















                                                    Creating a query             Add Table or Query
                                                                                     dialog box



               42       Plus (Ver. 3.2)-VIII
   39   40   41   42   43   44   45   46   47   48   49