Punjab Technical University 2006-1st Sem B.Sc Information Technology -IT Database4 Management with Microsoft Access - Question Paper

BSIT-102
Database4 Management with Microsoft Access
BSc IT (1st Semester)

Time: 3 Hours Maximum Marks:75

Note: 1. part A will be compulsory and have 15 short ans questions(40-60 words)of two marks every.
2. Section B will have 12 long ans ques. of five marks each, out of which candidate have to attempt nine ques.

Section – A Marks: two every

1.
(a) Why should an organization select to use integrated database to store its operational data?
(b) Why do you need a Data Base Management System?
(c) What are primary and foreign keys?
(d) What is Relational DBMS?
(e) What is relational data integrity?
(f) What kind of data model does Microsoft Access support?
(g) Why do we require forms?
(h) What is a Query?
(i) How to create many to many relationship in MS Access?
(j) What do you mean by importing and exporting of data?
(k) Define macro?
(l) What are different data kinds available in MS Access?
(m) What is pivot chart form?
(n) What is a difference ranging from form and report?
(o) What is a module?
Section – B Marks: five every
2. What are the characteristics of Quality information?
3. What are services given by a Database Management System?
4. Write a procedure to create form with a suitable example.
5. Use Microsoft Access to create a database named Emp with example of your own attributes of table Emo. Also describe primary key.
6. (a) What do you mean by filter?
(b) How to do filtering of data?
7. What do you prefer to linking or importing of data from other database? Why?
8. What is a Report Writing facility in MS Access? Write steps to create a report of Employees?
9. Discuss the methods of creating query.
10. Create a query with the subsequent specification. Get all the books whose title starts with ‘C’ AND price is greater than 1000 OR whose title begins with the letter ‘S’.
11. What are the steps involved in building a database application?
12. Write the steps to import the data in your database application?
13. Write the steps to create a report?

Earning:   Approval pending.