Working with external data


show more Working with external data provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 New Features show less
please wait ...

Working with external data

In Access 2010, the External Data Ribbon has been rearranged and many of the Import and Export tools have been improved. In importing, you now have a Linked Table Manager and ODBC Database has been moved up to this level. In both importing and exporting, the SharePoint List button has been moved down here under More. While most of the buttons are the same, Microsoft Office 2010 has so many new collaboration features that Access does a better job of importing and exporting than ever before. For example, enhanced integration with Outlook saves time and effort in entering information into your database.

You can now link directly to a Contact folder right in Outlook and update your contact data right from inside Access. I'll click on Link to the data source by creating a linked table, and OK. I'll come down here to the account that I want to use and click the plus sign. I'll point to their Contacts and say Next. I'll call this Outlook Contacts and click Finish. Now when I open it,...

Working with external data
Video duration: 3m 2s 36m 35s Intermediate

Viewers:

Working with external data provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 New Features

Subject:
Business
Software:
Access
Author:
please wait ...