NewswireTODAY - /newswire/ - Drummondville, Québec, Canada, 2006/06/08 - 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 the con's of the most popular desktop database in the world.

Too often i here developers complaining about Microsoft Access. Most of those complain are about user-written database applications. The case is that end users don't understand database design, they think "Access is just a fancy Excel." But given ANY tool they'll behave exactly the same way. You're talking about the application design, NOT about Access itself. You can see poor design in other tools like 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 you money.
- 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 make sure to do your backups regularly.
- You can scale up and connect to a SQL Server Database with a native access (Access Data Project).

When correctly use, Access offer an excellent alternative for the bigger database system like Oracle, DB2 or SQL Server. Of course if you have a lot of user connected at the same time to a database (more then 20...) or if your business as to run 24 -7 or if you need a web base application, Access is not a logical choice. In the other cases 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 will please your user.

Now imagine if you could start a project with a well documented MS Access Database Template that would make you save even more time and money, and help you learn Microsoft Access programming techniques at the same time. Your project could be up and running very quickly!

Eric Cote is a Microsoft Access Developer an Senior Programmer for Access-Template.

Agency / Source: MS-Template

Availability: All Regions (Including Int'l)

Traffic Booster: [/] Quick NewswireToday Visibility Checker

Distribution / Indexing: [+]