Basics of Computer

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