Payment Technology Blog

Explore our modern gateway designed to help you sell more, make more and keep more.

Tuesday, June 15, 2010

I love Microsoft Access

I have been using Microsoft Access personally since 1991. Seems so long ago. It was version 1.1 when I started with it.

Since that time, me and my team of developers have built literally hundreds of Access databases. Access is probably my favorite application to work in, with Excel a close second.

With Microsoft Access it is so easy to whip up forms, reports, queries, etc. It is probably the greatest data manipulation tool that I have seen, and I've worked with many different tools!

Best of all, it is bundled with a Visual Basic based programming language that allows you to perform any automation that you need. You can use Access as a front end to a SQL Server backend and have it connect with any of countless remote data sources.

I use Access daily personally to manipulate my own data and automate otherwise manual processes. We have Access databases linked up with our QuickBooks files to manipulate data there, as well as with many different SQL Server, MySQL and Access databases we work with.

That is why, when a new developer calls us looking to integrate payment process (credit card and/or ACH) into their Access based application, my heart soars. I love to see it. These integrations are just so easy - we can do them usually in an hour or less. And it is so seemless, that the developer, and the clients, are always beyond happy.

It is a beautiful thing! I do have a place in my heart for many other database packages as well - 4D and FileMaker to name a couple. Each tool should be suited for it's purpose, and every database package has it's strengths and weaknesses. For data manipulation, none surpass Access.

More information on Microsoft Access and Credit Card Integration.

No comments:

The biggest advantage of our gateway comes from power that it puts in the hands of your developers. Easily integrate with your application and take advantage of features to enhance your system.

We invite you to a live demo and the opportunity to build a partnership. Our promise to partners is, through innovation, today's products will be relentlessly enhanced into tomorrow's solutions.

1921-A Rohlwing Road
Rolling Meadows IL 60008-4800
P) 866-513-1547
F) 866-513-1548
info@transaxgateway.com