Results 1 to 6 of 6

Thread: Oracle and MS Access

  1. #1
    Junior Member
    Join Date
    May 2006
    Answers
    9

    Oracle and MS Access

    What the differences of these two databases? Which one is better to use?


  2. #2
    Shivanna
    Guest

    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.


  3. #3
    Junior Member
    Join Date
    May 2006
    Answers
    9

    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?


  4. #4
    Junior Member
    Join Date
    Apr 2006
    Answers
    24

    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?
    If considering platform independent DB, it would be good to get into Oracle else, You always have an option of SQL Server.


  5. #5
    Shivanna
    Guest

    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.


  6. #6
    Contributing Member
    Join Date
    May 2006
    Answers
    75

    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.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact