Page 103 - Trackpad_ipro 4.1_Class7
P. 103

Parameter Query: It is a type of select query that prompts you for the input before it runs. It
                    uses the input as the criteria for determining the result.

                    Action Query: It creates a new table or alters your data by adding, deleting, updating, and
                    appending data from it.
                    Crosstab Query: It shows your data in a grid with row and column headings, so you can see
                    and compare your information across two categories at once.
                 Clickipedia



                     Structured Query Language (SQL) is a fifth generation computer language for relational
                   databases  and data  manipulation. It is used to insert,  update,  and  retrieve  data  from a
                   database table.

                 Setting up Relationship


                 A relationship between two tables connects them through a common field. The field in the first
                 table is called the primary key, and the same field in the second table is called the foreign key.
                 The foreign key must match the primary key. To create this link, make sure both tables have a
                 primary key.
                 To create a relationship, create two tables:

                    Table named ‘StudentsDetail’ that holds general information about the students, such as their
                    Roll No, Student Name, Father’s Name and Class
                    Table named ‘StudentsMarks’ that holds information about Roll No, Marks and Percentage












                                                                                    Using tables for defining relationships

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


                                    1  Click on the Database Tools tab.          3  Click on the Add button.
















                    2  Click on the Relationships command.     4  After adding the desired tables, click on the Close button.




                                                                                               More on Access    101
   98   99   100   101   102   103   104   105   106   107   108