Page 92 - iPro_trackGPT_V5_Class7
P. 92
2. Primary key plays a very important role in a database. Justify the statement.
...................................................................................................................................................................................
...................................................................................................................................................................................
...................................................................................................................................................................................
3. Discuss the key components of Microsoft Access 2021 window and their functions.
...................................................................................................................................................................................
...................................................................................................................................................................................
...................................................................................................................................................................................
C. Application-based questions.
1. Your teacher wants a database of students' marks with automatic calculations of total
and percentage. How can you set this up in Access?
2. You are working on an inventory system for a store. How would you prevent
duplicate entries in the product database?
#Problem Solving & Logical Reasoning
Higher Order Thinking Skills (HOTS)
1. An organisation loses access to its database. What problems could arise, and how can
these issues be prevented?
2. Can a database help in detecting fraud or anomalies in financial transactions? How?
Code Clues #Experiential Learning
#Digital Literacy
Locate eight terms related to operating systems in the following grid:
W P P L A C C E S S M B
T R D K P U R V G H I R
D I H P T E M P L A T E
B M K M A L U R N D T P
D A T A B A S E O E B O
D R W L L P Q C X Z M R
G Y H S E T V O S H N T
D K S M L Y Q R Z H U N
H E J F I E L D P L M G
K Y I Y Q W C X I N G T
90 TrackGPT iPRO (V5.0)-VII

