MS-Access Previous Paper 2022
Khyber Pakhtunkhwa Board of Technical & Commerce Education Peshawar
Diploma in Information Technology
1st Term Examination 2022
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 MS Access? Explain the environment of MS Access with the help of Diagram.
Q.2: Define the following:
ii. Composite key
iii. Referential integrity
iv. One-to-one relationship
Q.3: Explain different data types available in MS Access.
Q.4: Write the steps:
i. How to set primary key in a table.
ii. How to add and delete record in a table.
Q.5: What is a join? Explain difference between relationships and join.
Q.6: Define form. Write the procedure, how to create form by wizard.
Q.7: What is data base security? Explain Different types of database security.
Q.8: Explain the following:
i. Select query
ii. Command button