Get premium membership and access revision papers, questions with answers as well as video lessons.

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


Popular Exams



Return to Question Papers