MS-Access Previous Paper 2022


0

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

Like, Share, and Follow Us!

Leave a Reply

Your email address will not be published.

Copyright © 2022 Basics of Computer