Ms-Access Previous-Paper 2014
Khyber Pakhtunkhwa Board of Technical Education Peshawar
Post Inter Diploma in Information Technology (New Course)
1st Term Examination 2014
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