Prabin Kalikote

The difference between Text and Memo field data type are:

The characteristics of the field that determines what kind of data it can store is known as field data type.
The list of datatype that can be used is M-Access are:
        - Text
        - Memo
        - Number
        - Date/Time
        - Currency
        - Auto Number
        - Yes/No
        - Attachment
        -...

The unique name that identifies data stored in the field is called field name.
The rules of naming fields are:
        - Field name can be up to 64 characters long.
        - Field name can contain letters, numbers, spaces or punctuation marks.
        - Field name cannot contain a period (.), accent grave (~), square bracket [ ] and exclamation mark ( ! ).
        - Field name cannot...

The term field can be defined as the column of the table of database which stores a particular category of data. Each field gives particular type of data of an entity. 
The term record can be defined as the row of a table of database which consists of the related data of a person or thing. Each record gives complete information of a person or thing.

All the data to be stored in database are stored in tables. It is also called the container of the database.

Table in MS-Access is the primary building block of a database which is used to store collection of related data of a specific topic, purpose or subject. It is also called the container of database because all the data are stored in tables.
We know, table is considered as the container of database as it store all the data of the data base. The data to be stored in the database are diverse and should be stored under various field topic for...

The file that stare all the sets of components or objects of MS-Access in order to manage the database is called database file.
Its extension is .ACCDB.