Page 103 - iPro_trackGPT_V5_Class7
P. 103
2. Identify the purpose of a Select Query in Access.
...................................................................................................................................................................................
...................................................................................................................................................................................
3. Differentiate between a Primary Key and a Foreign Key.
...................................................................................................................................................................................
...................................................................................................................................................................................
B. Long answer type questions.
1. Explain the different views available for forms in Microsoft Access and describe the
purpose of each view.
...................................................................................................................................................................................
...................................................................................................................................................................................
...................................................................................................................................................................................
2. Discuss the different types of queries in Microsoft Access.
...................................................................................................................................................................................
...................................................................................................................................................................................
...................................................................................................................................................................................
3. Mention the two ways to format a form in MS Access.
...................................................................................................................................................................................
...................................................................................................................................................................................
...................................................................................................................................................................................
C. Application-based questions.
1. Your teacher has asked you to demonstrate how to link two related tables
in Access. Explain the steps you would take and the benefits of creating
this relationship.
2. You and your friend have been given a task to design a database for managing a
school’s library system. How would you use Forms, Queries, and Reports to ensure
efficient data management and user interaction?
#Digital Literacy
Higher Order Thinking Skills (HOTS)
1. How can the use of forms in Access improve data entry and management for large
databases?
2. How does setting up relationships between tables in a database enhance data integrity
and reduce redundancy?
More on Access 101

