Page 107 - iPlus_Ver_2.0_class_7
P. 107
#Digital Literacy 4. What is an association between two tables on the basis of a common field called?
Let’s CatCh Up a. Structure b. Binding
Define the following terms: c. Relationship d. None of these
1. Field _____________________________________________________________________ B. Fill in the blanks using the words given below.
2. Sort _____________________________________________________________________ Hints: Select query, Title, Run, Logo, Relationship
3. Table _____________________________________________________________________
1. ................................ and ................................ are the commands present in the Header/Footer group on
4. Or _____________________________________________________________________
the Design tab.
2. ................................ retrieves data from one or more tables.
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.
C. 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. The data can be displayed in either descending or ascending
order during the run time. ................................
D. Match the following columns correctly:
Column A Column B
1. Layout View a. Header/Footer
2. Logo b. Query
3. Foreign Key c. Form
4. Crosstab d. Relationship
Section B (Subjective)
A. Short answer type questions:
1. What is a form in Access?
2. Name any two types of query.
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. Explain any four parameters that are displayed at the bottom of the Query window while creating
a query.
105
More on Access

