Page 108 - iPrime_V2.2_class7
P. 108
4. An association between two tables on the basis of a common field is called
................................ .
a. Structure c. Relationship
b. Binding d. Printing
B. Write ‘T’ for true and ‘F’ for false.
1. You can run the query only once. ................................
2. You cannot insert a picture in the form. ................................
3. Design view is used to change the appearance of the form. ................................
4. You can set multiple queries in a form. ................................
5. Select query allows us to retrieve data from a table. ................................
C. Fill in the blanks using the words given below:
Hints
Layout view, Title, Run, Foreign key, Logo, Relationship
1. ................................ and ................................ are the commands present in the Header/Footer
group on the Design tab.
2. ................................ is used to change the appearance and size of various controls of a form.
3. ................................ is established between two tables based on the common field..
4. After creating the query, we need to run the query by clicking on the ................................
button.
5. The field in the first table is called the primary key, and the same field in the second table
is called the ................................ .
Let's Do It Section B (Subjective)
A. Short answer type questions.
1. What is a form in Access?
2. Give any one use of the report object in Access.
3. Name the three main views in which a form can be displayed.
B. Long answer type questions.
1. Differentiate between query and report in Access.
2. Write the steps to create a report.
3. Write the names of any four parameters which are displayed at the bottom of the Query
window while creating a query.
106 Touchpad iPRIME (Ver. 2.2)–VII

