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.
0 Comments
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: One very common data management problem is integrating and synthesizing data from multiple data sources. How many different sources of data do you have to work with? And how are all these data sources related?
In general, Microsoft does a great job of providing integration capabilities between its products. Most folks, however, are not aware of all the fantastic opportunities to fully integrate MS Outlook and Access. Following are just some of the ways you can combine the capabilities of Outlook and Access:
|
Michelle MeyerArticles discuss data management integration Archives
November 2018
Categories |