Page 108 - Trackpad_ipro 4.1_Class7
P. 108
B. Long answer type questions.
1. Differentiate between query and report in Access.
...................................................................................................................................................................................
...................................................................................................................................................................................
...................................................................................................................................................................................
2. Write the steps to create a report.
...................................................................................................................................................................................
...................................................................................................................................................................................
...................................................................................................................................................................................
3. Explain any four parameters that are displayed at the bottom of the Query window while
creating a query.
...................................................................................................................................................................................
...................................................................................................................................................................................
...................................................................................................................................................................................
C. Application-based questions.
1. Neil is creating a registration form for a school event. He wants to add a logo and title in
this form. Which tabs and commands should he use to incorporate all these elements?
2. Ethan is designing a database for his online store. He wants to link the
'Customers' table with the 'Orders' table. If the 'Customers' table has a primary
key named 'CustomerID', what should the corresponding field in the 'Orders'
table be named, and why?
#Problem Solving & Logical Reasoning
Higher Order Thinking Skills (HOTS)
1. What is the default view in which a form will appear when first created in Microsoft Access?
2. Which type of form in Microsoft Access allows for viewing multiple book records
simultaneously to help identify overdue books?
Crack The Code #Experiential Learning
#Problem Solving & Logical Reasoning
Solve the crossword on the basis of given clues:
Across
1. Query parameter that forms the first row of the design grid
3. The key that uniquely identifies the records in a table
5. The form view that gives a detailed view of the structure of the form
106 iPro (Ver. 4.1)-VII

