Page 108 - iPlus_Ver_2.0_class_7
P. 108
C. Competency-based/Application-based questions:
1. Sahil wants to display data stored in a table in a user-friendly manner. Which feature of Access can
he use to do so?
2. You want to view the information in two categories at once. Which query will you create to do so?
3. Assertion (A): Anisha wants to compile data from three tables stored in a database using Microsoft
Access.
Reason (R): She can accomplish this by using the "Relationship" feature in Microsoft Access.
(a) Both Assertion (A) and Reason (R) are true and Reason (R) is a correct explanation of Assertion (A)
(b) Both Assertion (A) and Reason (R) are true and Reason (R) is not a correct explanation of Assertion(A)
(c) Assertion (A) is true and Reason (R) is false
(d) Assertion (A) is false and Reason (R) is true
#Problem Solving & Logical Reasoning
Crack The Code #Digital Literacy
Solve the crossword on the basis of given clues. 1
Clues: 1 F
Across 2
1. Query parameter that forms the first row of the design grid. 3 R R
4
3. The key that uniquely identifies the records in a table.
5. The form view that gives a detailed view of the structure
5 E G
of the form.
6. The feature of Access that searches and displays data
from more than one table. 6 R
Down
1. The key that matches the primary key.
2. It is an association between two tables on the basis of
a common field.
4. The feature of Access that organises and presents
data in a user-friendly format for printing.
#Experiential Learning
Let’s Explore
Surf the Internet and find out about more uses of Access. Discuss with your teacher.
106
iPlus (Ver. 2.0)-VII

