The synchronizing techniques in this chapter will allow you to maintain your contact data in a set of linked Access tables, adding any number of custom phone numbers and IDs as needed, and synchronize your Access data to Outlook contacts, so you can work with the standard properties of contacts in the convenient Outlook contact interface, and work with any additional custom fields you need in Access, without having to manually enter (and update) the same contact data in Access and Outlook.

In addition, you can use the denormalizing and renormalizing techniques used to work with contacts for any situation that requires converting a set of linked Access tables to a single flat-file table, or the reverse — something that is likely to arise when exchanging data with legacy programs or mainframe databases.

Earlier chapters in this book described how to work with Word, Excel, and Outlook, using VBA code to create Word documents, Excel worksheets, and Outlook items and fill them with data from Access. This chapter describes some more advanced techniques for working with other Office components, such as those you might need in a database with shipping and ordering information.

0 0

Post a comment