Statistics

[Guest]

Hello,

Although not directly an Access question, I've been asked to justify
implementing an access database to replace current working methodologies
(excel, word,...). Are there any good statistics on performance improvements
achieved by using databases (access in particular)? anything else of this
nature?

Thanks,

Daniel P

 

['69 Camaro]

Hi, Daniel.

Although not directly an Access question, I've been asked to justify
implementing an access database to replace current working methodologies
(excel, word,...).

These are different tools that do different jobs. An analogy would be, "If
I use a hammer instead of a phillips screwdriver, can I expect performance
improvements?" A hammer isn't the proper tool to use on screws. Extracting
the screw later will be difficult, and the screw may not hold the materials
together well, because the threads are stripped.

But it was much faster to drive the screws with the hammer!

However, if data is being stored and manipulated in Word or Excel instead of
in a database, then the question is: "Why are you using a hammer on those
screws?!!"

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.