Bmit 126: Business Application Software 2010/2011 Question Paper
Bmit 126: Business Application Software 2010/2011
Course:Business Application Software
Institution: Kabarak University question papers
Exam Year:2010
KABARAK UNIVERSITY
UNIVERSITY EXAMINATIONS 2010/2011 ACADEMIC YEAR
FOR THE DEGREE OF BACHELOR OF BUSINESS MANAGEMENT & INFORMATION TECHNOLOGY
COURSE CODE: BMIT 126
COURSE TITLE: BUSINESS APPLICATION SOFTWARE
STREAM: Y1S2
DAY: FRIDAY
TIME: 9.00 – 12.00 P.M.
DATE: 17/12/2010
INSTRUCTIONS:
Answer question 1 and any other 3 questions in section B
SECTION A
QUESTION ONE: (40 marks)
a) Describe structure of select case statement using a suitable example [6 Marks]
b) Given the following information, sketch the interface and write a program to
compute the total, average and grade
Mark > 75-100 Grade A
Mark 70 – 74 Grade A-
Mark 60 – 69 Grade B
Mark 50 -59 Grade C
Mark 40 -49 Grade D
Mark <=39 Fail
. [7 Marks]
c) Describe four data types used in Ms Access . [4 Marks]
d) (i) What is a procedure? [ 2 marks]
(ii) Describe the following procedures [ 4 marks]
(a) Event procedure
(b) General procedure
e) (i) What is array? [2 marks]
(ii) What are the rules used when declaring the array [ 4 marks]
f) Draw interface and write a visual basic program to perform arithmetic operations
[4 marks]
g) Explain the use of the following controls in visual basic [ 5 marks]
1) Data Tool
2) Time
3) Combo Box
4) List Box
5) Frame
h) Describe features of visual basic [2 marks]
SECTION B ANSWER ANY THREE QUESTIONS
QUESTION TWO: (20 Marks)
a) Explain any four data types used in visual Basic, providing example to each
[4 Marks]
b) Describe the steps used to link more than one table in Ms Access [4 Marks]
c) Describe any three looping control structures used in Visual Basic [6 Marks]
d) Explain any four comparison operators used in Visual Basic [4 Marks]
e) What is event? When is it used? [ 2 marks]
QUESTION THREE (20 Marks)
a) Explain the if else statement using a suitable example [4 marks]
b) Describe the Message Box () and the Input Box () and provide example for each case
[5 marks]
c) Draw the interface and Write a visual basic program to accept name ,emp No,
Department,Date of emp ,Basic pay, Hse ,Medical, Computing, Telephone allowances,
and tax will be calculated at 28% of the gross salary [5 marks]
d) Describe three ways used to create tables in Ms Access [ 6 marks]
QUESTION: FOUR (20 Marks)
a) Discuss any five mathematical functions used in visual basic [ 5 marks]
b) Draw the interface and write a visual basic program to compute sales man
commission using case statement
< 100 sales commission = 2 % of sales made
101- 200 sales commission = 5 % of sales made
201- 300 sales commission = 7 % of sales made
301- 500 sales commission = 9 % of sales made
> 501 sales commission = 12 % of sales made
[6 marks]
c) What is a menu? When it is used? [3 marks]
d) (i) What is a function ? [2 marks]
(ii) Explain two types of functions used in parameter passing [4 marks]
QUESTION FIVE: (20 Marks)
a) Describe four the windows that appear when you start Visual Basic interface
[4 marks]
b) Draw the interface and write a visual basic program to calculate simple interest over
a given period of time [ 5 marks]
c) Write a visual basic application to accept three inputs and perform the following Add
command, Update command and Exit command [6 marks]
d)(i) what is a variable ? [2 marks]
(ii) What rules to be followed when declaring it? [3 marks]
More Question Papers