Geeks Talk

Prepare for your Next Interview




Oracle and MS Access

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?...


Go Back   Geeks Talk > Databases > Oracle

Register FAQ Members List Calendar Mark Forums Read
  #1 (permalink)  
Old 06-01-2006
Junior Member
 
Join Date: May 2006
Posts: 9
Thanks: 0
Thanked 4 Times in 4 Posts
Allan Paul is on a distinguished road
Oracle and MS Access

What the differences of these two databases? Which one is better to use?
Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 06-02-2006
Contributing Member
 
Join Date: May 2006
Posts: 34
Thanks: 0
Thanked 9 Times in 6 Posts
Shivanna is on a distinguished road
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.
Reply With Quote
The Following User Says Thank You to Shivanna For This Useful Post:
  #3 (permalink)  
Old 06-04-2006
Junior Member
 
Join Date: May 2006
Posts: 9
Thanks: 0
Thanked 4 Times in 4 Posts
Allan Paul is on a distinguished road
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?
Reply With Quote
  #4 (permalink)  
Old 06-05-2006
Junior Member
 
Join Date: Apr 2006
Posts: 29
Thanks: 6
Thanked 12 Times in 5 Posts
pat.mclean is on a distinguished road
Re: Oracle and MS Access

Quote:
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?
If considering platform independent DB, it would be good to get into Oracle else, You always have an option of SQL Server.
Reply With Quote
  #5 (permalink)  
Old 06-05-2006
Contributing Member
 
Join Date: May 2006
Posts: 34
Thanks: 0
Thanked 9 Times in 6 Posts
Shivanna is on a distinguished road
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.
Reply With Quote
  #6 (permalink)  
Old 06-24-2006
Contributing Member
 
Join Date: May 2006
Posts: 76
Thanks: 0
Thanked 3 Times in 3 Posts
blenda is on a distinguished road
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.
Reply With Quote
Reply

  Geeks Talk > Databases > Oracle


Thread Tools
Display Modes


Similar Threads

Thread Thread Starter Forum Replies Last Post
Oracle Interview Questions Free E-Book admin Downloads 277 1 Week Ago 02:16 AM
Dual Table in Oracle janelyn Oracle 12 2 Weeks Ago 06:44 PM
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


All times are GMT -4. The time now is 04:43 PM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0
Copyright © 2008 GeekInterview.com. All Rights Reserved