Merits and Demerits of creating a database in Excel 2010

Asked By xscripter 0 points N/A Posted on - 07/23/2016

What are the merits and demerits of creating a database in Excel 2010? I know, there are many programming software for creating well organised Database, but I want to know that, do MS Excel 2010 can also stand up to the mark?

• Status: Open
• Question Views: 370
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Access

Answered By w3zone 0 points N/A #128773

Merits and Demerits of creating a database in Excel 2010

Yes, Excel is able to perform as a Database Application, and you can do everything in it as you would have done in any programming language. But, there are some limitations also, as Excel may get slow when burdened with huge workload. Here are the advantages and disadvantages of creating database in Excel 2010:

Advantages:

• First, as MS Office is already installed in Windows, you don’t need any other external software.

• Second, you can learn the Excel VBA Programming, since you already know about Excel.

• From Excel, you can always upgrade your Database platform to Access, SQL, etc.

• Excel provides a number of assets to create your financial modules.

• In Excel, you can share your database via E-mail.

Disadvantages:

• If you use complex formulas, or big amount of data, your program execution can get slow.

• Excel files can get lost, if you break a large database into smaller files.

• The number of rows and columns are limited in an Excel sheet.

About w3zone

Questions
2

Answers
2

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 07/23/2016
• Question Category: MS Access