DIY Guide to Selecting the Right Tool for the Database Project

As any person, who remodeled their home, will tell you that "choosing the right tool for the right job" makes all the difference. The same statement applies when choosing the right database for a project. Some databases are basic, some are "battery operated" and some are "mighty power tools." Below is a guide on selecting the perfect database for the right project.

When you only need to store a limited amount of data and require a quick and easy development cycle, Microsoft Access is the right tool for you. It provides a powerful set of database and graphical user interface tools that allows the user to quickly organize, access and share information. Since Access is part of the Microsoft family of office products, it easily integrates with Excel, Word, and SQL Server. In addition, it supports Open Database Connectivity (ODBC). However, if the database is going to hit 1GB threshold, … Read More