MS-Access Previous-Paper 2019
Khyber Pakhtunkhwa Board of Technical Education Peshawar
Diploma in Information Technology
1st Term Examination 2019
Time allowed: 3 hours
Max marks: 100
Note: Attempt any five questions. All questions carry equal marks. Mobile phone and programmable calculator are not allowed.
Q1. Discuss table object. Write steps to create a table.
Q2. Define database. Explain database features in detail.
Q3. Discuss any four data types in MS-Access.
Q4. Discuss reports. Write the steps to create a report by design.
Q5. a) Write down steps to create Combo Box.
b) Discuss List Box and Check Box.
Q6. What is query? Discuss types of query.
Q7. Explain the following terms in detail.
i. Primary key
ii. Secondary key
iii. Foreign key
Q8. Explain the following terms in detail.
i. Join query
ii. Command button