DISTANCE EDUCATION
B.C.A./B.C.A. (Lateral) DEGREE EXAMINATION, MAY 2017.
LAB III — ORACLE AND VISUAL BASIC
Time Three hours Maximum 100 marks
Examiner has to select and give ONE question to each
candidate from lot system.
1. Write a VB program to print twenty address labels
in a two-column format for the address
The Registrar
Periyar University
Salem 627007
Create a table BLOOD with the following fields.
DNO, DNAME, DOB, DAGE, DADD, DCITY,
DGRP, DSEX.
Add 5 records.
Display the information of donors in the age
groups 20 to 25.
Display the information of donors having 0+.
Display the information of female donors with
age between 20 and 25.
Sub. Code
36
DE-9514
ws19
2
2. Write a VB program to print the simple and
compound interest through labels.
Create a table pay with the fields.
Emp. No, Name, Basic pay, DA, HRA, DED, Gross
pay and Net pay.
Add 5 records (except DA, HRA, DED grosspay
and Net pay)
Fill DA with 70% of basic pay
Fill HRA with 1,400 Rs.
Fill DED with 1,000 Rs.
Fill Gross pay with the sum of basic pay, HRA
and DA
Fill Net pay with Gross pay-DED.
3. Write a VB program to compute the surface area
and volume of a sphere.
Create a table LABEL with the fields
Name, street, city, pincode
Add 5 records.
Display the ascending order sorted list with
the name as primary key.
Display the descending order sorted list with
the city as primary key.
Display the contents with appropriate
headings.
Cut here
DE-9514
ws19
3
4. Write a VB program to display the day of the given
data. Also convent the given word into upper case.
Create a table marks with the fields
Regno, Name, M1 M2, M3, Total, average, grade.
Add 5 records
Replace all total with M1 M2+ M3
Replace average with Total/3
Replace grade
Grade is A if average 60
A if average is 40 to 59
C if average is 60
Display the maximum and minimum marks
in each subject.
5. Write and test a VB program to compute and print
either the sum of odd numbers or even numbers at
the user's choice using Label, text and option
button.
Create a table Address with the fields
Name, street, city and Pincode
Add 5 records
Display the structure of a table.
Add field district.
Fill all district field as Chennai.
Change the Pincode to 630003 where city is
Karikudi and Pincode is 620003