MS-Access Previous Paper 2022

Khyber Pakhtunkhwa Board of Technical & Commerce Education Peshawar
Diploma in Information Technology
(Part -II)
1st Term Examination 2022
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 MS Access? Explain the environment of MS Access with the help of Diagram.
Q.2: Define the following:
i. Entity
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
Related Posts
User Story Confusion: Creating and Breaking Them Down
Unlock the secrets of user story confusion with the Carnsa Development series! Join Bob, the bright son of the Carnsa family, as he enlists the help of his granny to break down user stories into manageable chunks. Discover proven techniques and strategies to help you and your team create and implement user stories with ease.
Order your copy of 'User Story Confusion: Creating and Breaking Them Down' now!
