Page 64 - Computer - 8

Lab Work Computational Skills

A. 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.
B. Create a table containing the details of teachers in a coaching institute with the following fields:

Field name Data type Properties
TeacherId AutoNumber Primary Key
Name Short text Field size: 20
Address Long Text Field size: 50
JoinDate Date/Time Format: Medium date
Experience Number Validation Rule: >= 0

Subject Short Text Field size: 20
Class Number Validation Rule: >=2000
Salary Number 2 decimal places
(a) Enter ten records in the table.
(b) Create a form for the table using Form Command.
(c) Create a query to display records of all Physics teachers.
(d) Create a query to display records of the teachers whose experience is 5 years or more.
(e) Create a report to display records grouped by Subject.

DISCUSS
DISCUSS Communication Skills
Can the function of a report or a query be performed directly on the data in a table using the Datasheet
view? Discuss with your classmates.

TEACHER’S DESK
TEACHER’S DESK
Explain to the students the use of different database objects. Motivate them to create queries and reports that
display data in different ways from the same table.

62