Sunday, March 25, 2012

Week 10: Clear - Compatibility of Access

Among database management tools, Microsoft Access is hands down the easiest to use. Microsoft Access is a desktop database management tool, which comes bundled with some versions of Microsoft Office suite.  Access allows a fairly proficient computer user to create databases for just about anything.  The use cases of databases are endless. You can store data in a relational database, run queries on the data, create forms for data entry, and create stunning reports analysis of the data to be more understandable.  One limitation of Access is its availability for Mac users, because for some reason this software is not compatible with Mac computers.


Microsoft Access is a great database management solution for start-up companies, small businesses, and home offices.  With its wide range of abilities and features, its low cost of purchasing and ownership, and ease of use, Access is the software of choice for many.  Microsoft Office products are very user friendly and are well documented , so if you need help with making or managing your database, help is readily available.

At my previous employer, they relied on a self-made Access database program with forms for data entry and reporting.  The fields used calculations to reconcile companies' escrow bank sheets.  The owner of the company created the program using Access 2000 and used it in production for servicing their clients.  They soon grew out of the custom Access database program and had to transition to a more robust relational database.  At the time, it was superseded by creating and managing the companies relational databases using Microsoft Visual Fox Pro 8.

No comments:

Post a Comment