Get premium membership and access revision papers, questions with answers as well as video lessons.
Got a question or eager to learn? Discover limitless learning on WhatsApp now - Start Now!

Scs 114:Introduction To Spreadsheet Question Paper

Scs 114:Introduction To Spreadsheet 

Course:Bachelor Of Science

Institution: Maseno University question papers

Exam Year:2012



MASENO UNIVERSITY
SCS 114:INTRODUCTION TO SPREADSHETS AND DATABASES
ANSWER all questions
QUESTION 1
a)Define the following concepts:
i)Application package
ii)spreadsheet
iii)Module
b)State three diference between a function and a formula
c)Show how MS Excel would evaluate the following expression:
5+2*2^(3-1)
d)State five advantages of using Ms Access to store data over MS Excel
e)State and explain five different sections of an MS Access report
f)Explain the role of the following MS Access 2007 field properties
i) caption
ii)Input mask
iii)Validation rule
iv)Validation text
QUESTION 2
a)Explain the following concepts stating their usefulness in a database design
i)Validity integrity
ii)Entity integrity
iii)Referential integrity
b)State and explain four sections of an MS Access 2007 form
c)Explain five different database models






More Question Papers


Popular Exams



Return to Question Papers