Ms-Access Previous-Paper 2014

Categories : DIT , DIT Previous Papers 2014

Khyber Pakhtunkhwa Board of Technical Education Peshawar
Post Inter Diploma in Information Technology (New Course)
1st Term Examination 2014
Paper: MS-Access 

Time allowed: 3 hours

Max marks: 50

Note: Attempt any five questions. All questions carry equal marks. Mobile Phone & Programmable Calculators are not allowed.

Q.1: – Define database. Discuss advantages of electronic database
Q.2:- What is Key? Explain Primary Key, Foreign Key and Secondary Key.
Q.3 :- Describe application window of Ms-Access. List its different parts.
Q.4:- Write steps to create table by using wizard
Q.5:- Write Query for below table to obtain the records of those students in descending order by Roll. No. Who belongs to Peshawar (district and having marks greater than 600.
Student (Roll No, S-Name, Marks , Class, District).
Q.6:- What is Form? Discuss various types of Forms.
Q.7:- What is Report? Write steps to create Reporting Wizard.
Q.8:- Write short note on any two of die following.

i) Types of Report
ii) Difference between Relation and Join
iii) Uses of Design View of Table

Related Posts

Like, Share, and Follow Us!

Leave a Reply

Your email address will not be published. Required fields are marked *

Copyright © 2024 Basics of Computer