Answer Posted / kani

1.Oracle is multi-user where MS-Access is not.

2.Oracle's features for distributed transactions,
materialized views and replication are not available with
MS Access. These features enable Oracle to efficiently
store data for multinational companies across the globe.
Also these features increase scalability of applications
based on Oracle.

3.We can't create sequence in Microsoft Access.We create
sequence in Oracle.

4.Oracle database is more secured than MS-Access. Oracle
can handle a database having million records very
efficiently, but MS-Access has no such quality like Oracle.

5.oracle is client server technology based while Ms-Access
is not.

6.Oracle follow 11 rule of E.F CODD and access follow 7
rule, oracle give better query performance in comparison to
access, oracle perform high security feature like system
manager, oracle can store unlimited data in access limit.

What format should my database be saved in to allow different versions of Microsoft Access to open the database?

812

---

What are the protection features in ms access?

824

---

What is the size limitation of an Access database?

807

---

Is sql similar to access?

782

---

How do you use microsoft access database?

836

---

What has replaced microsoft access?

880

---

Is access faster than excel?

725

---

Is microsoft access free?

726

---

how to toggle ms word to ms excel or ms excel to ms word

2006

---

What is the difference between a form and a report in access?

830

---

Can you purchase just microsoft access?

753

---

Is microsoft access a sql database?

806

---

Is ms access part of ms office?

892

---

You need to migrate the ms access database tables to oracle. What steps will you take?

763

---

What can be done with microsoft access?

720

---