Page 103 - iPlus_Ver_2.0_class_7
P. 103

•  Crosstab Query: It is a query that uses a row heading and a column heading so that you can
                   see your data in terms of two categories at once.

                    Info Byte

                     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

                 An association between two tables on the basis of a common field is called a relationship. The
                 common field in the first table is called the Primary Key, and in the second table it is called the
                 Foreign Key. The foreign key field must match with the primary key field in the first table. To
                 create a relationship between two tables, we first need to create a primary key in both tables.

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

                   Roll No, 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:

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












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










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