Page 97 - Trackpad_ipro 4.1_Class7
P. 97
...................................................................................................................................................................................
...................................................................................................................................................................................
D. Application-based questions.
1. Ranjeet is working on a database of a school. He wants to view all the records in a
sequential manner either in ascending or descending order. Suggest a feature of Access
that can help him do this.
2. Jennifer is a student who wants to keep track of her monthly expenses. She
decides to use a computer program that allows her to create a database with
columns like 'Date', 'Item', 'Amount', and 'Category'. Which type of database
is Sarah most likely to use track her monthly expenses, and can you name an
example of this type of database?
Higher Order Thinking Skills (HOTS) #Interdisciplinary
1. To determine which students scored above 90% on their last computer test, which
database object should be used to retrieve this information?
2. When entering details about new students into an Access 2019 table, where within the
Access window should the student information be typed?
Crack The Code #Experiential Learning
Find six terms related to Access 2019 in the following grid:
P A B E A U T B D E Z L
R S N L S O M E M N D O
I M O O Z N L A D F A R
M T Q U E R Y L M L T Q
A L M S F E T O M Q A B
R Z Y U L P M T A Q B F
Y X L N M O S A L A A M
K S U V P R T B M R S Z
E L L O P T S L N F E A
Y M N F O R M E L Z Y B
SDG Activity
Create a database in Access to track and analyse waste management in
your school. Input data on daily waste generated, recycled, and disposed
of, then generate reports to identify patterns and suggest ways to reduce
waste, promoting responsible consumption and production. Discuss your
findings with your class to propose sustainable practices.
Database and DBMS—An Introduction 95

