Page 109 - Trackpad_ipro 4.1_Class7
P. 109
6. The feature of Access that searches and 1
displays data from more than one table 1 F
Down 2
3 R R
1. The key that matches the primary key
4
2. It is an association between two tables on
the basis of a common field 5 E G
4. The feature of Access that organises and
presents data in a user-friendly format for
printing 6 R
#Digital Literacy
#Creativity & Innovativeness
Create a table for the Students Details.
a. Show the relationship between the two tables based upon the common field.
b. Create a form for the Students Details table. Enter the following records through the
form:
Gyan Shanker 8 B
Richa Sinha 6 A
c. Write a query to find the Book Name, Publication, Student Name, Class, and Price from
both the Students Details table and Library Management System tables.
d. Generate a report of the query created.
More on Access 107

