Check out my latest EzineArticle…
Microsoft Access is frequently criticised for its scalability and migration limitations, but this is often unfair. The following article starts to explain why.
Microsoft Access Database: The Pros With Less Cons When Using Microsoft Access As Your Database
I remember trying to piece together a database using Microsoft Access finding that it just wouldn’t provide the functionality and usability I was looking for, getting very frustrated with it and that I just wanted to buy a piece of ready-made software and start running reports.
The problem for me at that time (and we are talking about 1993) was buying software that really met my objectives and being cost effective at the same time; which really didn’t exist. Even today, it’s still expensive and there is no ‘out of the box‘ software solution that will provide and fulfill your full objectives.
Since Access is part of the Microsoft Office (Professional) suite then you already have invested in the software before you start. Now you need to assess the product functionality and scope for your requirements and Microsoft Access should satisfy most if not all requirements.
The advantages (pros) of Microsoft Access are:
- A return on your investment – this being the most cost effective solution that you or some knowledgeable person can control.
- Quick development time – since the objects and components are ready made with various wizards and templates, you are up and running in quick time.
- Integration with other Office applications – Access works with all Microsoft software and is particularly happy with Excel and Pivot tables at a click of a button (or two).
- Easy to deploy – sharing an Access database over the network (LAN) is straightforward and there are several approaches to this methodology.
- Connecting with other databases – using Microsoft Access as the front-end, you can use alternative and more scalable back-end database applications namely Microsoft SQL Server.
- Great and easy reporting – Microsoft Access has a built-in reporting tool that not many other database applications can claim as a standard feature.
- VBA programming – is available for the more professional and polished database system that can be considered a little more exclusive if using a third-party vendor.
I’m not going to spoil the party and talk about the cons here though they’re always some when working with an Access database. But if you are looking for better security (for sensitive processes) or want better back-ups, roll-backs and a large audience of (20 plus) concurrent users, then some further research is required as Microsoft Access will not always be the perfect tool.
Another Tip for you! With the later versions of Microsoft Access databases (2007 & 2010), you now have better web and online capability sharing your data abd reports via the internet which really promotes this feature from a con to a pro too!
I invite you to keep up to date with my articles and eBooks which covers a lot of details and can be found at https://AccessDatabaseTutorial.com.
Check out my special offers at https://AccessDatabaseTutorial.com/Offer.
From Ben Beitler – “Your Access Database Expert”
Microsoft Access Database – My Additional Point
Most database applications are relatively small amounts usually under 100 MB. This is well within the capabilities of Microsoft Access, and using a product like Microsoft SQL Server would be unnecessary for the smaller database.
With modern hardware being more powerful, RAM (memory) is large enough to process higher volumes of data.