QP: Visual Basic

GUJARAT TECHNOLOGICAL UNIVERSITY

B.E. Sem-Vth Examination December 2010

Subject code: 150706

Subject Name: Visual Basic Applications and Programming

Date: 21 /12 /2010

Time: 03.00 pm – 05.30 pm

Instructions: Total Marks: 70

  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 & VBADifference between VB and VBA 03
(b) Define Array.Explain Fixed and Dynamic Array with example. 04
(c) How the variable is declare and discribe the different types of Variables with example 07
Q.2 (a)(i) How Do…While loop is executed ?Explain in Brief With Example(ii) Explain following properties of Listbox control:

  1. List count
  2. Multiselect
  3. ListIndex
0403
(b) What are Events? Explain Mouse Event in brief with example. 07
OR(b) Explain configuration Macro security setting in detail. 07
Q.3 (a) Write step for creating and executing MacrosPossible Answer Link 1 04
(b) What is Procedure? Define the scope of private and public procedure with example 07
(c) Write a program to enter the year and check whether it is leap year or not. 03
ORQ.3 (a) What is command bar? Explain Brief to create menu bar and explain how to create shortcut keys in menu. 07
(b) Explain the Four different types of Operators with example. 04
(c) Write common Method for control.. 03
Q.4 (a) Write a VB Program to implement Standard Calculator. 07
(b) How to create a new document in VBA? 04
(c) Explain Frame control with its different properties.Possible Answer Link 03
ORQ.4 (a) A form has File Handling Controls to view Picture file name from a path of drive and folder one picture box to display selected Picture file. Write appropriate program for this application 07
(b) Explain the following function with example

  1. ABS()
  2. MOD()
  3. IsDate()
  4. LCase()
 

  • 02
  • 02
  • 02
  • 01
Q.5 (a) Write a procedure to access the database using ActiveX control 07
(b) Discuss the following:

  1. Property window
  2. Object Browser
  3. Break Points
03
(c) Explain Timer Control with its propertiesPossible Answer Link 04
ORQ.5 (a) Define function.How to pass arguments in function? 04
(b) Describe MSGBOX() and INPUTBOX() with example 03
(c) Explain Error Handling . 07

One thought on “QP: Visual Basic

  1. I?m impressed, I have to say. Really hardly ever do I encounter a blog that?s each educative and entertaining, and let me tell you, you have got hit the nail on the head. Your idea is outstanding; the problem is one thing that not enough persons are speaking intelligently about. I’m very blissful that I stumbled throughout this in my seek for one thing relating to this.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s