Download GTU BE/B.Tech 2018 Winter 5th Sem Old 150706 Visual Basic Application And Programming Question Paper

Download GTU (Gujarat Technological University) BE/BTech (Bachelor of Engineering / Bachelor of Technology) 2018 Winter 5th Sem Old 150706 Visual Basic Application And Programming Previous Question Paper

www.FirstRanker.com
1
Seat No.: ________ Enrolment No.___________

GUJARAT TECHNOLOGICAL UNIVERSITY

BE - SEMESTER ?V (OLD) EXAMINATION ? WINTER 2018
Subject Code:150706 Date: 07/12/2018

Subject Name: Visual Basic Application & Programming

Time: 10:30 AM TO 01:00 PM Total Marks: 70

Instructions:

1. Attempt all questions.

2. Make suitable assumptions wherever necessary.

3. Figures to the right indicate full marks.

Q.1 (a)
What is VBA? State the Difference between VB & VBA
07
(b)
How Do?While loop is executed ?Explain in Brief With Example
07

Q.2 (a)
Explain configuration Macro security setting in detail.
07
(b)
Explain different types of Operators with example.
07
OR
(b)
Explain following :
[i] On Error Go To Label
[ii] On Error Go To 0
07

Q.3 (a)
VBA is not a true object oriented programming language- justify. Also Explain
following OOP properties in detail:
[1] encapsulation
[2] polymorphism
07
(b)
Explain need of adding ActiveX control. Also discuss how ActiveX created once can
be used in different projects.
07
OR
Q.3 (a)
Define following:
[1] Database Management system
[2] Primary key
07
(b) Explain code window , property window and object browser in visual basic 07

Q.4 (a) Explain various control structure used in VBA with suitable example 07
(b) Compare property of Check box and option button with suitable example 07
OR
Q.4 (a)
Write a VBA code which accepts 10 numbers in an array and displays the count of even
and odd numbers in the array
07
(b)
Write a note on fixed arrays and dynamic arrays.
07

Q.5 (a)
1. Write a VBA code using Select-Case statement that displays the day of the week
depending on the value of an integer variable.
07
(b)
What is a timer control? State the properties and events of timer control with the help
of example.
07
OR
Q.5 (a)
Accept the enrollment number, name and marks of all subjects of semester 7 in
textboxes and display the total, percentage.
07
(b)
What is Procedure? Define the scope of private and public procedure with example
07

*************
www.FirstRanker.com www.FirstRanker.com
www.FirstRanker.com
FirstRanker.com - FirstRanker's Choice