One of the most common uses of Microsoft Access is in data integration projects. Because Quickbooks is so popular, it’s not uncommon for folks to ask me about integrating Quickbooks data with Microsoft Access data. Most of the time, they are seeking to compare and reconcile financial information.

Data connectors are the first tool of any integration project. Without data connectors it’s not possible to join information across multiple intelligence sources.
 
Some of the best Microsoft Access features are its built-in data connectors. Microsoft Access was part of the Microsoft Office Suite from the very beginning. Because of this Microsoft has always provided information integration capacities. With just a few clicks it is currently possible to connect to information stored in:

There was a time, before computers, when we literally could not get our hands on the data we needed to make decisions. And now, 25-30 years later, we have so much data that we’re drowning in it.

​As technology and software have evolved, the sheer amount of data we have to manage in our work place has increased exponentially. Anymore, it’s not uncommon to have multiple sources of data in any given office.