Ms access vs Oracle

Microsoft Access, also known as Microsoft Office Access, is a database management system from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools. It is a member of the Microsoft Office suite of applications, included in the Professional and higher editions or sold separately. Microsoft Access stores data in its own format based on the Access Jet Database Engine. It can also import or link directly to data stored in other applications and databases.[1] Software developers and data architects can use Microsoft Access to develop application software, and "power users" can use it to build software applications. Like other Office applications, Access is supported by Visual Basic for Applications, an object-oriented programming language. Oracle Database (commonly referred to as Oracle RDBMS or simply as Oracle) is an object-relational database management system produced and marketed by Oracle Corporation. The Oracle RDBMS stores data logically in the form of tablespaces and physically in the form of data files. Table spaces can contain various types of memory segments, such as Data Segments, Index Segments, etc. Segments in turn comprise one or more extents. Extents comprise groups of contiguous data blocks. Data blocks form the basic units of data storage. A DBA can impose maximum quotas on storage per user within each table space. Oracle, MS Access, and any other vendor's database package all have their advantages and disadvantages. Selecting one over another is really a case of weighing the advantages and disadvantages for your specific case. MS Access - This package is very cheap (it is part of Office Professional) and very easy to use. Most of the work in Access is done through wizards and GUI tools. One can quickly develop a small, single user database with this one. MS Access is not very good for a multi-user application. It is not very robust and does not have good multi-user transactional control. In addition, Access cannot handle large amounts of data. All of the data in the database is stored in a single file and that has its limitations.MS Access is a small database with limited database functionality following 7-8 CODES rule of perfect database. Oracle - This package is not cheap at all. It is very complex and it can be difficult to administer. But its complexity makes it very robust. There is almost nothing that you cannot do in Oracle (unlike Access). Oracle is specifically designed for multi-user applications. In fact, thousands of users can access the same data without any problems due to Oracle's very good transactional control. But applications are not developed nearly as quickly. Oracle can also handle large amounts of data. In fact, Oracle 8i can handle up to 512 petabytes of data! Oracle provides more security than access. It can handle much more complicated databases. Oracle is a closest of being a perfect RDBMS. Oracle is based on client server approach and must be installed to host application. Oracle is a server based database. In the end, Oracle is a true Database Management System (DBMS) and Access is not. This does not mean that Access does not have its place. If you are designing a quick database that only you will use, you can do it in Access over Oracle. If you are designing a robust, scalable application used by many users, then Oracle is the better choice!