Page 108 - TP_iPlus_V2.1_Class7
P. 108
B. Fill in the blanks using the words given below.
Hints: Criteria, Action, Layout, Primary key
1. ................................ query creates a new table or alters your data by adding, deleting, updating, and
appending data from it.
2. To create a relationship between two tables, we first need to create a ................................ in both
tables.
3. ................................ parameter of Query window is used to display the condition on the basis of which
the records will be filtered.
4. The Form Design window appears with the first record of the table in the ................................ view.
C. Write ‘T’ for true and ‘F’ for false.
1. By default, the form contains first three field labels from the table and their
corresponding text boxes. ...........................
2. The appearance of the form can be changed by using the various options
available on the Design and Format tabs. ...........................
3. The Query Design command is present under the Queries group on the Query tab. ...........................
4. An association between two tables on the basis of a common field is called
a relationship. ...........................
5. The key that uniquely identifies the records in a table is called Primary key. ...........................
D. Match the following columns correctly:
Column A Column B
1. Multiple Items a. Query
2. Parameter b. Descending or Ascending order
3. Background Image to Form c. Form
4. Sort d. Format Tab
Section B (Subjective)
A. Short answer type questions:
1. Name the three main views in which a form can be displayed.
2. Name the four new tabs that appear on the ribbon of the Report window.
3. Define reports.
B. Long answer type questions:
1. Explain the types of queries in Access.
2. How can you set up relationship between two tables.
3. Explain the types of basic forms available in Access.
106
iPlus (Ver. 2.1)-VII

