MS-Access Previous (Past) Paper 2016
Khyber Pakhtunkhwa Board of Technical Education Peshawar
Diploma in Information Technology
(Part -II)
1st Term Examination 2016
Paper: MS-Access
Time allowed: 3 hours
Max marks: 100
Note: Attempt any five questions by selecting at least one question from each section. All questions carry equal marks. Mobile phone and programmable calculator are not allowed.
Q1: Define database table. Write down the advantages of electronic database.
Q2: Define relationship. Explain different types of relationship.
Q3: Define table. Write the procedure of creating table by wizard.
Q4: Explain following filed properties.
i) Field Size
ii) Caption
iii) Required
iv) Validation Rule
v) Validation Text
vi) Default Value
vii) Input Mask
Q5: Write down the procedure of the following.
i) Creating Delete Query
ii) Creating Append Query
Q6: Define and explain database security.
Q7: Explain different data types available in Ms-Access.
Q8: Define report. Write the steps for creating report by wizard.
Related Posts
Basics of Computer By Muhammad Umar
Basics of Computer, Third Edition, eradicates any intimidation about the computer. With a minimal investment of time, you’ll soon be able to understand basic concepts and perform simple tasks on your computer.
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!
