1What makes MS Access different from MS Excel 2Microsoft Acc

1-What makes MS Access different from MS Excel?

2-Microsoft Access is one of the most popular database platforms on the market. However, there are many competitors. Why do you think that Access is so popular? What are some of the other types of databases available?

Discuss the differences between Access and its competitors. Are there truly any differences or are they the same technology implemented in different ways?

Solution

1-What makes MS Access different from MS Excel?

A)

i)The main difference between Ms Access and MS excel is Microsoft Access is a database management program, Microsoft Excel is a spreadsheet application.

ii)Access used for data management where as excel used for data analysis.

iii)Access used for automation common events where as excel used for calculations and comparisons.

iv)Access used for generating reports for final summary where as excel used for generating chart

Management and conditional formatting.

2ANS)There are many data bases available in market Microsoft Access is one of the most popular database why because,

1)it has provided many ways to use the Office suite applications together, such as using data stored in Access inside a excel spreadsheet.
2)Microsoft have one of the applications in Microsoft\'s office’s suite It is often sold as part of an Office suite bundle. Since it is part of the Microsoft Office suite, the user interface is similar to the other Office suites applications, all of which are market leaders in their category.

3)MS Access have ability to combine solutions like create, modify, and manage databases along with the tools that allow no-programmers to create queries, forms, and reports inside one application.

MS Access competitors:

we have MySQL, Microsoft\'s SQL Server ,Oracle Database are IBM\'s DB2 data bases also available in market and they are designed to be used as client-server databases where the database resides on a server and applications that access the data run on other computer i.e a user\'s desktop computer.

Differences between Access and its competitors:

1) Microsoft Access provided the functionalities such as database creation, database management, and data reporting require separate applications.

2) Microsoft supplies SQL Server for corporate database needs.

3) MS Access does not implement stored procedures, database triggers, or transaction logging.

4) MS Access is probably not a good choice for a corporate database solution. It has limitation of database size and the total number of concurrent users.