Prabin Kalikote

The process of viewing required records of the table that satisfies the specified criteria is meant by filtering records.

The process of arranging the records in increasing or decreasing order is meant by sorting records.

Default value is the property that specifies the value which is automatically entered in a particular field when the new record is added.

Indexing is the process of setting up the indexed property that speed up searching and sorting in a table based on key values:
The different indexing options available in MS-Access table are:
        - No -----> No indexing.
        - Yes (No duplicates) -----> Indexing with no duplicates.
        - Yes(Duplicates OK) ------> Indexing with duplicates.

The process of checking whether entered data meets certain conditions or limitation or not is data validation.
Its importance are:
        - It helps us to be confirmed about the data.
        - It helps us to limit the input ranges.

The difference between Format and Input mask field are:

Different subtypes of number fields are:        
        - Byte 
        - Integer
        - Long Integer
        - Single precision
        - Double precision
The default size of a number field data type is -2 billion to + billion.