UNIVERSITY EXAMINATIONS: 2011/2012
YEAR 3 EXAMINATION FOR THE BACHELOR OF SCIENCE IN
INFORMATION TECHNOLOGY
BIT 4202 ADVANCED APPLICATION PROGRAMMING
DATE: APRIL 2012 TIME: 2 HOURS
INSTRUCTIONS: Answer Question One and Any other Two Questions
Question one
a) Describe the main Table Types used in application development [9 Marks]
b) i) Define an array [2 Marks]
ii) Provide syntax to show how arrays are declared in VB.net [2 Marks]
iii) Explain the following references to array elements: [4 Marks]
AmountDecimal(3)
StatesString(6)
c) Describe the two ways used to fill a List control in VB and explain situations where each way is
best suited. [5 Marks]
d) i) Define a MenuStrip control as used in VB [2 Marks]
ii) Explain why menus are preferred to command buttons in application development [2 Marks]
iii) Menus often have hot keys. Describe how you can add a hot key to a menu in VB.net using an
example to illustrate. [4 Marks]
Question Two
a) i) Define ADO.NET as used in VB.NET [2 Marks]
ii) Explain two roles played by ADO.NET in application development today [4 Marks]
iii) Describe four different types of ADO.NET connections to databases across networks[8 Marks]
b) Visual basic provides three controls to enable an application user to select from a list of items: List
and describe these controls [6 Marks]
Question Three
As a software developer you have been hired by a firm that needs to be able to quickly compute the
value of any item in the inventory. Design the solution, build a form that will enable inputting values
into three textboxes: (1) product description, (2) quantity on hand, and (3) product cost. Clicking a
Compute button should display the total value of the inventory product to an output textbox. Clicking
a Reset button will reset the form. Clicking an Exit button will close the form. Set Option Strict On.
Design the user interface [20 Marks]
Question Four
a) Describe the general format of the Block If statement as used in VB [4 Marks]
b) State and explain four rules to be followed when using the block if statement in VB [8 Marks]
c) Draw a flow chart to represent the following code segment [6 Marks]
If HoursDecimal <= 40D Then
‘Pay only regular time
GrossPayDecimal = Decimal.Round(HoursDecimal * PayRateDecimal, 2)
Else
‘Pay regular time + overtime
GrossPayDecimal = Decimal.Round((40D * PayRateDecimal) + _
((HoursDecimal – 40D) * PayRateDecimal * 1.5D), 2)
End If
d) Using examples explain the term logical operators [2 Marks]
Question Five
a) Describe the four levels of variable scope in VB [8 Marks]
b) Explain the use of the following common VB controls [12 Marks]
i)TextBox
ii) MaskedTextBox
iii) GroupBox
iv Richtexbox
v) CheckBox
vi) PictureBox
