Page 45 - Code & Click - 8

3. The tab that provides options to create a form for a table is ______.
(a) Home (b) Forms (c) Create (d) External
4. 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. 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. _______
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. Maanvi 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

Lab Work Computational Skills

Create a table containing the details of salesmen who earned commission in the year. The table should
contain the following fields :
Field name Data type Properties
SalesmanNum Number Field size: 6, Primary Key
SalesmanName Short text Field size: 25

Zone Short text Field size: 6
Commission Number Validation Rule: >= 0
(a) Enter ten records in the table.
(b) Create a query to display records of all salesmen who earned a commission of ` 10000 or more.
(c) Create a report using Report Wizard to display records grouped by zone.

43