Recommended: Click here to improve PC speed »
A Microsoft Access Database Template, Why and When to Use It
Microsoft Access could be an essential part of your business information strategy.You need to know when to use it and why. Here's the pro's and con's of the mostpopular desktop database in the world.
Drummondville, QC - 2006-06-16
Too often i here developers complaining about Microsoft Access. Most of thosecomplain are about user-written database applications. The case is that end usersdon't understand database design, they think "Access is just a fancy Excel." Butgiven ANY tool they'll behave exactly the same way. You're talking about theapplication design, NOT about Access itself. You can see poor design in other toolslike Sql Server or Oracle.
So why choose Microsoft Access as your development platform ?
- It comes with Microsoft Office Professional and so you may already have it.- The use of Microsoft Access help reduce development cost and time thus saving youmoney.- It can be used on networks with over 20 simultaneous users.- Microsoft Access integrates tightly with Microsoft Office.- Access is the industry standard -- it's well supported and training is easy to find.- You don't need a big team of technician to take care of the database. Just makesure to do your backups regularly.- You can scale up and connect to a SQL Server Database with a native access (AccessData Project).
When correctly use, Access offer an excellent alternative for the bigger databasesystem like Oracle, DB2 or SQL Server. Of course if you have a lot of user connectedat the same time to a database (more then 20...) or if your business as to run 24 -7or if you need a web base application, Access is not a logical choice. In the othercases it's the most economic solution because of the rapid development environment.In a fraction of the time you can produce a professional application that willplease your user.
Now imagine if you could start a project with a well documented MS Access DatabaseTemplate that would make you save even more time and money, and help you learnMicrosoft Access programming techniques at the same time. Your project could be upand running very quickly ! Find out more at www.access-template.com
Eric Cote is a Microsoft Access Developer an Senior Programmer for Access-Template
Contact Eric Cote for more insights into this topic. Email:ericote@access-template .com Other helpful information regarding this product can befound at: http://www.access-template.com
For More Information Contact:
Eric Coteericote@access-template.c omwww.access-template.com
