UNIVERSITY EXAMINATIONS: 2011/2012
YEAR 2 EXAMINATION FOR THE BACHELOR OF SCIENCE IN
INFORMATION TECHNOLOGY
BIT 2105 APPLICATION PROGRAMMING
DATE: APRIL 2012 TIME: 2 HOURS
INSTRUCTIONS: Answer Question One and Any other Two Questions
QUESTION ONE (COMPULSORY 30 MARKS)
a) Differentiate between ADO and DAO data controls as used in Visual Basic stating clearly which
you would prefer when creating a database application and why. (6 Marks)
b) In Visual Basic, there are 2 types of procedures. Describe them using examples (6 Marks)
c) Visual Basic stores code in 3 kinds of modules: describe each briefly. (9 Marks)
d) i) Explain the need for reports in application development (3 Marks)
ii) Describe how you can create a report in VB 6 (6 Marks)
QUESTION TWO (20 MARKS)
a) Differentiate between the following controls
i) Picturebox and Image control
ii) Option button and Check box control
(4 Marks)
b) The value of the variable in a procedure is local to that procedure in VB. Explain the
significance of this characteristic of VB procedures (4 Marks)
c) Define the following terms and clearly show how they are declared and initialized:
i) Variable
ii) Constant
iii)Array
(6Marks)
d) Describe the following argument passing mechanisms as used in VB. (6Marks)
i) Passing by reference
ii) Passing by Value
QUESTION THREE (20 MARKS)
a) i) Using an example to illustrate explain why lists are useful in many user interfaces today
(4Marks)
ii) Describe two ways used to populate a list in VB (6 Marks)
b) Briefly describe any TWO advantages of using sub procedures or functions in a program.
(4Marks)
c) Describe three different ways of declaring variables in VB (6Marks)
QUESTION FOUR (20 MARKS)
a) List any 3 objects and 3 events used in VB and explain their functions. (6 Marks)
b) List and briefly describe 4 flow control constructs supported by Visual Basic. (4 Marks)
c) Briefly explain the difference(s) between design-time and run-time modes in Visual Basic.
(4 Marks)
d) Explain briefly the following events stating one possible use for each.
i) Form Load
ii) KeyPress
iii) Query Unload
(6Marks)
QUESTION FIVE (20 MARKS)
You have confirmed with senior management that the Statement of User Requirements for your project
is acceptable and you are now able to proceed to the development stages. Your are considering the
possibility of using Rapid Application Development Techniques (RAD).
List :
a) the advantages of using RAD (10 Marks)
b) the risks associated with this approach (10 Marks)
(Total 20 Marks)
