Creation of Database in MS Access :
Table creation in MS Access :
To give a name to the table for this process right click on table1 choose Design View to save as table name then click ok.
To enter field names of table using click on view > Design View
To insert a data into the table :
To get the data name like starting with " S " : Like "s*"
Data types :
| Data type | Size |
| Short Text | 255 |
| Long Text | 63,999 |
| Number | 1,2,4,8 bytes 16 bytes for Replication ID |
| Date/Time | 8 bytes |
| Currency | 8 bytes |
| AutoNumber | 4 bytes |
| Yes/No | 1 bit |
Replication ID :
A Replication ID makes a terrible choice as a primary key. Access provides the Replication ID data type to uniquely identify records in a replicated database. GUID is used in replication. GUID 8EC7B8E3-3B51-4C0C-8481-7AEEF9074EBE.
Replicated database :
Data Replication is simply copying data from a database from one server to another server so that all the users can share the same data without any inconsistency.
