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

