Q.1: Tick the correct Option.

1. Primary key can be set on a relation by using menu in MS-Access

(a) File

(b) Edit

(c) View✅

(d) Format

2. Memo data type can store up to characters.

 (a) 255✅

(b) 256

(c) 35565

(d) 64000

3. What symbol indicates that you are editing a records from a table.

(a) Record view

(b) Datasheet View✅

(c) Design view

(d) Edit view

4. How many types of relation can be used?

(a) 2

(b) 3✅

(c) 4

(d) 5

What is the term for a characteristic or attribute of an object that determines how the object looks and behaves.

(a) Color

(b) Property✅

(c) Size

(d) Orientation

Q.2: Give answer to any eight short questions of the following.

1. Define cardinality of relation.

2. Define datasheet view.

3. What are characteristics of a relation?

4. Describe required property of field.

5. What does cascade delete men?

6. Write two advantages of using query..

7. What is parametric query?

8. What is difference between relationship and join?

9. What is difference between sorting and filtering?

10. What are wildcards?

Q.3: Give answer to any two questions of the following.

 (a) What is filter? Discuss different types of filter in MS Access in detail.

(b) Explain different types available in MS access.