Page 53 - ModularV1.1 _c8_flipbook
P. 53
D. Short answer type questions.
1. What is a query?
................................................................................................................................................................................
2. What is relationship?
................................................................................................................................................................................
3. Write the names of any two parameters of the design grid.
................................................................................................................................................................................
E. Long answer type questions.
1. Write the steps to create a query.
2. What is a Crosstab Query?
In the lab Subject Enrichment
Create a table for Library Management System.
Book ID Book Name Publication Price Quantity
10001 Gulliver’s Travels Paper Back 180 5
10002 The Time Machine Rupa 200 4
10003 Oliver Twist Macmillan 210 10
10004 Diary of a Wimpy Kid Penguin 150 5
Create a table for Student‘s Details.
Book ID Student Name Class Section Issue Date
10001 Niharika 8 C 20-10-2020
10003 Deepak 7 A 10-11-2020
10004 Nisha 8 B 09-10-2020
Set Book ID as the Primary key in both the tables.
Create the relationship between both the tables.
After creating both the tables, make the following queries:
l Display the Book ID, Book Name, Student Name and Class where Book ID is 10001.
l Display the Book Name, Student Name and Section where Section is A.
1. Explain the concept of query.
2. Explain different types of queries to the students.
Queries in MS Access 51

