Page 63 - Computer - 8

INFO RETENTION
INFO RETENTION

A. Select the correct option for each of the following statements.
1. The database object that is used to extract information from a database is ______.
(a) Report (b) Macro (c) Table (d) Query
2. The button in Simple Query Wizard screen that lets you remove all selected fields from the query
is ______.

(a) (b) (c) (d)
3. The tab that provides options to create a form for a table is ______.
(a) Home (b) Forms (c) Create (d) External
4. The tab that provides option to create a report is ______.
(a) File (b) Home (c) Create (d) Insert
5. You can create a form for a table with pre-designed layouts by using the ______.
(a) Form Wizard (b) Form command (c) Split Form (d) Form Design
B. Fill in the blanks with the correct answer.

1. _______ serve as the primary data repository in an Access database.
2. The _______ guides you through a series of steps and generates a report based on your specification.
3. The data retrieved by a _______ is displayed in the Datasheet view.
4. The _______ lets you create and format a form according to your specifications.
5. A _______ lets you view data from a table or a query in printable format.
C. Write ‘T’ for True and ‘F’ for False statement.
1. You can add new records to a table by using a form. _______
2. A query in Access can be saved and executed anytime when required. _______
3. Split form creates a new form that shows both the form and the Datasheet view. _______

4. The Report Wizard allows you to create a customised report with selected fields. _______
5. When you create a query using the Query Wizard, the Query Tools Design tab _______
appears on the Ribbon.
D. Answer the following questions.
1. What is a Query? Write the steps to create a query using the Query Design.
2. What is a Form? Write the steps to create a form using the Form command.
3. What is a Report? Write the steps to create a report using the Report Wizard.

4. Write the steps to add a new record to a table using a form.

Mind Stretching
1. Manvi maintains the database of all items in her departmental store. She wants to display the
details of all the products of a particular brand. Which database object she should use to perform
the task? Logical Thinking

2. The class teacher maintains the database of all the students in her/his class. She/He wants to
print the details of students who have not submitted their Holiday Homework. Which database
object she/he should use to perform the task? Critical Thinking

61