Prepare for your Next Interview
|
Welcome to the Geeks Talk forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
This is a discussion on Oracle and MS Access within the Oracle forums, part of the Databases category; What the differences of these two databases? Which one is better to use?...
|
|||||||
| Oracle Oracle 9i & Oracle 10g Knowledge Base Learn and Share Oracle Technology related articles, white papers, tutorials / study materials, example codes, FAQ's, Tips and Tricks. |
![]() |
| LinkBack | Thread Tools | Display Modes |
|
|||
|
Re: Oracle and MS Access
Basically both are Databases and have their own advantages.
MS-Aceess is a single application wherein you can create tables, queries, forms, reports, macros, modules, create custome menu bars, create relationships, create addins, web pages - everything will be in one place and you can just carry that one file - .mdb / .mde The power of MS-Access lies in developing an application almost instantly. The report that comes along with MS-Access is second to none. A fairly experienced person in MS-Access can alomost instantly provide new forms, new reports and / or modify exisiting ones according to day-to-day requirements. Its comparably simple and easier to maintain the database. Like all good applications, MS-Access has its own limitation too, MS-Access if suitable for small to medium sized applications. Their may be a limit to the size of the database too. MS-Access is limited in terms of security and stability. That is for MS-Access Oracle is much biger is every sense, It is vast technology, It includes much more than just database management. Oracle is suitable for large applications, It is known for its stability and for its security. It takes an Expert to maintain oracle database. |
| The Following User Says Thank You to Shivanna For This Useful Post: | ||
|
|||
|
Re: Oracle and MS Access
Thanks for that information. May I ask another question. If oracle is better than MS Access, what database should I master in looking for a good job in database? Is MS Access have good pay also?
|
|
|||
|
Re: Oracle and MS Access
Quote:
|
|
|||
|
Re: Oracle and MS Access
Choose between Oracle or SQL Server for a good careeer and good pay.
MS Access may not get you as many opportunities. Even in terms of pay - Opting for MS Access may fetch you much lesser when compared to other major database. All the while both Oracle and SQL Server are in a different league altogether. We may not do justice comparing MS Access with the gaints. |
|
|||
|
Re: Oracle and MS Access
In short to say each has its own advantage and the real usage of each depends on the needs. If one wants to have huge volumes in terms of usage, cost, security, users everything it is without any thought wise to make the selection of oracle. MS-access would prove good for small single application. So first make an idea about your usage, need and then go for it.
|
![]() |
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Oracle Interview Questions Free E-Book | admin | Downloads | 308 | 1 Hour Ago 06:06 AM |
| Dual Table in Oracle | janelyn | Oracle | 20 | 03-30-2009 08:10 AM |
| Letters of Oracle | janelyn | Oracle | 3 | 11-30-2007 03:06 AM |
| What is Oracle Net Services | GeekAdmin | Oracle | 2 | 02-15-2007 06:02 AM |
| Transaction in Oracle Server | janelyn | Oracle | 2 | 10-13-2006 07:03 PM |