Ms-Access Previous-Paper 2014
Khyber Pakhtunkhwa Board of Technical Education Peshawar
Post Inter Diploma in Information Technology (New Course)
(Part-II)
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
Basics of Computer By Muhammad Umar
Recent Posts
Ask a Question
Do you have any questions? Rest assured, we're here to provide answers. Join us in our forum where you can engage in fruitful discussions, ask your queries, and receive insightful responses from our esteemed authors and community members. We look forward to your active participation and valuable contributions as we collectively explore various topics. Let's come together and share your thoughts!