Access vs Excel as a DB

[Digitborn.com]

Hello,

There are many examples and aspects to compare these 2 products but I just want to point one little difference which is quite crucial and interesting.

Generally if you use small amount of data - 1 Worksheet / 5000 rows / 20 columns you can use Excel without bothering about the execution time, queries and work fast and convenient with it.

The point on Excel is that in 1 Column/Row you can differently Format the data(cells). For example - format as Number or Hour the cells in Column B depending on the data in other columns. That saves you from making 2 Columns - one for Numbers and another one for Hours. This helps you to save 1 of the columns when the data structure in other column is the same.

In Access (and generally all SQL DBs) this is not possible.

I'm interesting in your thoughts about it?

 

[Digitborn.com]

The coffee thing...this is a real problem. I should declare the cup, the coffeee and the oven as Objects and do some Methods on them I wonder when Microsoft finally make available all Excel and VBA options to the wanted users