Kerala University 2005 B.Com XI-COMPUTER APPLICATION--II - Question Paper

FOURTH SEMESTER B.Com. DEGREE EXAMINATION, APRIL/MAY 2005
(Vocational Course)

Branch : Tourism and Travel Management

Paper XI-COMPUTER APPLICATION--II
(2000 admissions)

Time : 2 Hours Maximum : 50 Marks
part A
ans any 5 ques..
every ques. carries two marks.


1. How will you sort a data base in Excel ?
2. What are the 3 views in a query ?
3. What is meant by a nested loop ?
4. What are the various icons displayed by a message box ?
5. What is a container ?
6. What are the default security kinds in Tally ?
7. What happens if the Tally lock is removed ?


part B
ans any 5 ques..
every ques. carries five marks.

8. How will you create a chart in Excel ?
9. What is a query and how do they work in MS-Access ?


(5 x two = 10 marks)

10. Summarise the rules for naming functions. How are numeric functions distinguished from string

functions ?

11. List command button properties in VB.

12. Explain how we can use the VB menu editor.

13. How will you create a company in Tally ?

14. What is a Balance Sheet ? How will you configure balance sheet in Tally ?

(5 x five = 25 marks)




part C
ans any 1 ques..
The ques. carries 15 marks.



15. Write a complete BASIC program that will create and utilize a sequential data file containing
names, addresses and telephone numbers. Include a provision for every of the subsequent features :-
(a) Add a new record.
(b) Display a record, based on the name. (c) Delete a record based on the name. (d) Display the entire records.

16. What is a Purchase Order ? discuss how can we create, alter and delete a purchase order in Tally.
(1x15=15 marks)

Earning:   Approval pending.