Page 110 - TP_iPlus_V2.1_Class7
P. 110
#Experiential Learning
Let’s Explore
Examine the three types of relationships that can be established between tables in
MS Access.
#Digital Literacy
#Creativity & Innovativeness
Practical Time
For a school database, create the following two tables:
Student Fees
Stud_admno Stud_admno
Stud_Name Stud_Name
Stud_class Stud_stream
Stud_section Stud_fees
Stud_dob
1. Establish the relationship between the two tables.
2. Create two forms: one for the Student table and another for the Fees table.
3. Enter five records in each table using the above created forms.
4. Use a query to display the student name, class, and fees, sorted in descending order by fees.
Teacher’s Corner
1. Discuss how to create a report using data from multiple tables.
2. Describe the concept of a primary key and a foreign key, and provide examples.
3. Explain the various search criteria options available in queries.
108
iPlus (Ver. 2.1)-VII

