Punjab Technical University 2006-1st Sem M.B.A DCA - MICSOFT ACCESS - Question Paper

MICSOFT ACCESS (NEW)
DCA, IST Semester (2096)

Time: 3 Hours Max Marks:75

Note: Attempt all ques. In Part A and any 9 ques. from Part B. every ques. in Part A and Part B carry two and five marks respectively.


PART A
1.
a. Write any 2 important benefits of Microsoft Office 2000.
b. What is meant by windows repair?
c. What is application’s workspace?
d. What is the need of databases?
e. How are DBMS and RDBMS related?
f. What is the need of data integrity?
g. Define any 2 database properties available in Access?
h. What is a table in Access?
i. What is a foreign key?
j. How is sorting various from filtering?
k. What is meant by static report?
l. Give the general Syntax of choose statement.
m. Give any 2 advantages of SQL.
n. What is QBE?
o. When is APPEND quesry required?

(15x2=30)

Part B
2. What is new in Microsoft Office4 2000?
3. What features are available in office 2000 to work with several documents?
4. Describe any 2 toolbars of Access.
5. What is a database? elaborate advantages of database?
6. What are the various kinds of DBMSs?
7. Write the features of RDBMS.
8. How will you create a table in Access? discuss with an example.
9. Write the steps to create a form in Access to accept user name/ Password pair.
10. Describe the ans wizard of Access.
11. What are the various kinds of reports?
12. How will you create a table using SQL?
13. Give examples of update and delete queries using QBE.

Earning:   Approval pending.