Difference between DBMS/RDBMS and Access/SQL server

DBMS/RDBMS

1. RDBMS= DBMS + referencial integrity- RDBMS follows 12 rules of CODD
2. In DBMS relation is between two files, while in RDBMS relation is between 2 tables.
3. DBMS doesnt support client server architecture , while RDBMS supports
4. DBMS doesnt follow Normalization, while RDBMS follows
5. DBMS consist of files, records , while RDBMS consist of relations, tables, tuples
6. DBMS -allow one user access at a time, while RDBMS allow multiple user simulations

Access/ SQL Server

1. Access follows file sharing architecture and network trafic is high, while SQL server follows client server architecture and network trafic is low- scalability and reliability
2. Access- is not relieable . It directly interact with access file, if in middle transaction fails then not recovered, while SQL server is reliable, transaction is recovered
3. When it comes to cost and support access is better than SQL. In case of SQL server you have to pay for per client licence, but for access runtime is free.
4. When your application has to cater to huge load demand, highly transactional environment and high concerrency then its better to use SQL.