Page 107 - TP_iPlus_V2.1_Class7
P. 107
#Digital Literacy
Let’s CatCh Up
Define the following terms:
1. Field _____________________________________________________________________
2. Sort _____________________________________________________________________
3. Table _____________________________________________________________________
4. Or _____________________________________________________________________
To Sum Up
A form is a database object used to create, edit, and display data stored in tables in a
user-friendly manner.
A query is the most important object provided by Access that can give you information
that you might not be able to find by looking at the table directly.
A report in Access is a feature which allows you to organise and present your data in
a user-friendly format so that it can be printed.
An association between two tables on the basis of a common field is called a relationship.
Exercise
Section A (Objective)
A. Tick (3) the correct option.
1. Which view allows you to enter, edit, and view data in a form?
a. Design View b. Layout View
c. Form View d. Datasheet View
2. To place the image of the company/ organisation, choose the ................................ option.
a. Logo b. Title
c. Image d. Picture
3. Which type of form should be used when you want to show form in two sections.
a. Multiple Items b. Datasheet
c. Split form d. Modal Dialog
4. What type of query prompts you for input before it runs and uses the input as criteria that controls
the result?
a. Select Query b. Crosstab Query
c. Action Query d. Parameter Query
105
More on Access

