Join Alicia Katz Pollock for an in-depth discussion in this video Working with external data, part of Access 2010 New Features.
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, I have a live link between the two.…
- Working with Application Parts
- Implementing the Table Tools ribbon
- Using Quick Start and calculated fields
- Designing with Layout View formatting tools
- Taking advantage of enhancements to the Conditional Formatting feature
- Automating with macros
- Working with external data
- Integrating SharePoint publishing
Skill Level Intermediate
Q: My macro isn't running correctly. I followed along with the author and I'm not receiving an error message, but the actions are performed correctly.
A: There are several possible reasons why a macro would malfunction. Make sure that the macro is written correctly. Capitalization and punctuation matters. Also make sure to click in all the same places when recording the macro. With enough practice, building macros will become more routine, and spotting errors will becoming easier.