GTU Visual Basic Application and Programming Question Paper Dec 2010
GUJARAT TECHNOLOGICAL UNIVERSITY
B.E. Sem-Vth Examination December 2010
Subject code: 150706
Subject Name: Visual Basic Applications and Programming
Instructions: Total Marks: 70
- Attempt all questions.
- Make suitable assumptions wherever necessary.
- Figures to the right indicate full marks.
Q.1 (a) What is VBA? State the Difference between VB & VBA
(b) Define Array.Explain Fixed and Dynamic Array with example.
(c) How the variable is declare and discribe the different types of Variables with example
How Do.. .While loop is executed ?Explain in Brief With Example Explain following properties of Listbox control:
- List count
What are Events? Explain Mouse Event in brief with example.
Explain configuration Macro security setting in detail.
Write step for creating and executing Macros
What is Procedure? Define the scope of private and public procedure with example
Write a program to enter the year and check whether it is leap year or not.
Q.3 (a) What is command bar? Explain Brief to create menu bar and explain how to create shortcut keys in menu.
(b) Explain the Four different types of Operators with example.
(c) Write common Method for control.
Q.4 (a) Write a VB Program to implement Standard Calculator.
(b) How to create a new document in VBA?
(c) Explain Frame control with its different properties.
Q.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 (b) Explain the following function with example
Q.5 (a) Write a procedure to access the database using ActiveX control
(b) Discuss the following:
- Property window
- Object Browser
- Break Points
4. Explain Timer Control with its properties
Q.5 (a) Define function. How to pass arguments in function?
(b) Describe MSGBOX() and INPUTBOX() with example
(c) Explain Error Handling . 5.