GUJARAT TECHNOLOGICAL UNIVERSITY
BE - SEMESTER-V (OLD) EXAMINATION - WINTER 2018
--- Content provided by FirstRanker.com ---
Subject Code:150706 Date: 07/12/2018Subject Name: Visual Basic Application & Programming
Time: 10:30 AM TO 01:00 PM Total Marks: 70
Instructions:
1. Attempt all questions.
--- Content provided by FirstRanker.com ---
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
--- Content provided by FirstRanker.com ---
(b) Explain different types of Operators with example. 07OR
(b) Explain following : 07
[i] On Error Go To Label
[ii] On Error Go To 0
--- Content provided by FirstRanker.com ---
Q.3 (a) VBA is not a true object oriented programming language- justify. Also Explain 07
following OOP properties in detail:
[1] encapsulation
[2] polymorphism
(b) Explain need of adding ActiveX control. Also discuss how ActiveX created once can (7
--- Content provided by FirstRanker.com ---
be used in different projects.OR
Q.3 (a) Define following: 07
[1] Database Management system
[2] Primary key
--- Content provided by FirstRanker.com ---
(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 07
--- Content provided by FirstRanker.com ---
and odd numbers in the array(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 07
depending on the value of an integer variable.
(b) What is a timer control? State the properties and events of timer control with the help 07
--- Content provided by FirstRanker.com ---
of example.OR
Q.5 (a) Accept the enrollment number, name and marks of all subjects of semester 7 in 07
textboxes and display the total, percentage.
(b) What is Procedure? Define the scope of private and public procedure with example 07
--- Content provided by FirstRanker.com ---
This download link is referred from the post: GTU BE/B.Tech 2018 Winter Question Papers || Gujarat Technological University
--- Content provided by FirstRanker.com ---