Question:What do the following formatting symbols mean in Format properties of fields? 
<, >, @"NULL", @"Not entered", $ 

< Display contents in lower case
> Display contents in upper case
@"NULL" Displays NULL if left empty
@"Not entered" Displays 'Not entered' if field is empty
$ Right aligns text in column

Question:What is the use of Validation Rule property of a field? 

Validation rule property allows specifying what validation must be made for the data entered in the field. if anything is specified in the validation rule property, only the data that satisfies the condition specified can be entered, all other data is rejected.

Question:What is 'Input Mask' field property? 

Input mask specifies the format in which the data must be entered. For example if phone number must be displayed as (977) 428-0628 enter the input mask property as !(999) 000-0000;;_

Question:What is the use of Validation Text property of a field? 

When the data entered in a field does not confirm to the validation rule that is specified, an error message is displayed on the screen that informs the user what is wrong. Validation text is used to display custom error message instead of default error message.

Question:How can you import a table created in another database or other file formats? 

Access provides facility to import tables from other database or other file formats such as excel workbook. To import a table Choose 'File > Get External Data > Import'. Alternatively, you can choose Import option on New Table dialog box.

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.