Question:How can you view the entire data of memo field?
In dat asheet view you can directly enter text but if you wish to view entire data of memo field you need to open the zoom window. To open zoom window press Shift+F2.
Question:What is the easiest way to define a relationship between two tables?
To define relationship between two tables, the easiest way is by dragging the primary key field of parent table and drop on the foreign key field of child table, then click 'Create'.
Question:What do you understand by Referential Integrity in Relationships?
Referential Integrity is a rule says that table must not contain any unmatched foreign key values. For example there can't be a fees record for a student who is not enrolled.
Question:What is the effect of enabling 'Cascade Delete Related Fields' when defining relationship?
If cascade delete related fields option is enabled, Access automatically deletes related records in the child tables if the record from master table is deleted. For example if a student is removed then all the records related to the student must be deleted from fees table, marks table and so on.
Question:What is the effect of enabling 'Cascade Update Related Fields' when defining relationship?
If cascade update related fields option is enabled, Access automatically updates the key field value of related records in the child tables if the primary key field value from master table is updated. For example if a student roll number is changed then all the roll numbers of that student must be updated in fees table, marks table and so on.