Difference between "ORACLE" and "MICROSOFT ACCESS" databases?

Oracle can handle much complicated databases, while Access is just a small database with limited database functionality

oracle provides more security then access

Qracle is a most closest of being a perfect RDBMS (flollowing more then 11 rules of Dr. EF Codd)

Where as Access is just a database following 7-8 CODES rule of perfect database...

Ms-Access is file server . An application can run without installing Ms-Access which using MS-access as backend. And Oracle is based on Client/Server appraoch , must be installed to host application

oracle is a server based databae while the ms acces is only for local datbase we can use oracle as a lacal data base.but normly we have used oracle as server based .

Hi,

Here oracle holds  Terabytes of Data.But MS-Access we can't holds the Terabytes of Data.

Some features in Oracle like platform independent,Index tunning and Tables spaces.

But Ms-Access not platform independent no indexes..etc..

But Oracle pricing more.comparitivly MS-Access.

Oracle is ORDBMS (Object Oriented Relational DataBase) while Access is RDBMS(Relational DataBase) only.

Oracle is more secure than MS Access.
Oracle stores unlimited data while MS
Access is not.
Sequence creation is not possible in MS Access.
Oracle is scalable but not
MS Access.