Bmgt 121-Computer Programming For Business 2009 Question Paper
Bmgt 121-Computer Programming For Business 2009
Course:Bachelor Of Commerce
Institution: Kabarak University question papers
Exam Year:2009
COURSE CODE: BMGT 121
COURSE TITLE: COMPUTER PROGRAMMING FOR BUSINESS
STREAM: Y1S2
DAY: WEDNESDAY
TIME: 2.00 – 4.00 P.M.
DATE: 12/08/2009
INSTRUCTIONS:
Answer QUESTION ONE and Any other TWO.
QUESTION ONE: (30 Marks)
a) State and explain any four data types used in MS Access? [8 marks]
b) (i) What is a procedure? [2 marks]
(ii) Discuss any three types of procedures as used in Visual Basic [6 Marks]
c) Describe structure of select case statement using a suitable example [6 Marks]
d) What is array? [2 marks]
e) (i) What is a function? [2 marks]
(ii) Explain the following term pass by value. [2 Marks]
f) What is the purpose of message box and input box. [2 Marks]
QUESTION TWO: (20 Marks)
a) Explain any four data types used in visual Basic [4 Marks]
b) Differentiate between variables and constants as used in programming. [4 Marks]
c) Write a visual basic code to perform arithmetic operation. [8 marks]
d) Explain the following Numeric operations
1) Abs()
2) Sqr()
3) Sgn()
4) Log()
[4 Marks]
QUESTION THREE: (20 Marks)
a) Explain any three looping control structures used in Visual Basic [6 Marks]
b) When is lookup wizard used in MS Access. [4 Marks]
c) Explain any four controls used in Visual Basic [4 Marks]
d) Explain any three modules used in visual basic. [6 Marks]
QUESTION FOUR: (20 Marks)
a) Explain any four string function as used in Visual Basic [4 Marks]
b) Describe three ways to create a form in MS Access [4Marks]
c) What is a menu? When is it used in Visual Basic? [4 Marks]
d) What are relationships? What is its advantage in Ms access [4 Marks]
e) Using a suitable example explain the following terms front end and back end.
[4 Marks]
QUESTION FIVE: (20 Marks)
a) Describe how computers can be classified based on their operating system.
[6 Marks]
b) Explain pass by reference . [2 Marks]
c) State and explain any five applications of computers in business [4 Marks]
d) Develop an interface together with a VB code that calculates the simple interest over a certain
period of time. [5 Marks]
e) Explain the if statement as used in Visual Basic [ 3 marks]
More Question Papers