Join Alicia Katz Pollock for an in-depth discussion in this video Integrating SharePoint publishing, part of Access 2010 New Features.
Access 2010 integrates with SharePoint Server, allowing others in your…organization to view or modify your data, even if they don't have Access.…SharePoint Server is Microsoft's Enterprise solution for sharing data between…departments in any organization.…Access 2010 now integrates with the SharePoint, so that you can use it to…distribute your information to others over the Internet.…Note that this is not Web publishing per se, but specifically making use…of SharePoint Server.…The easiest thing to do is to start with a blank web database, or one of the…templates that's web friendly.…
You can also convert an existing Access file to a Web database.…To do this, click on Save & Publish and click here on Publish to Access Services.…The first thing you want to do is Check Web Compatibility.…And because it turned red, I have some issues.…I would open up this table.…Make these changes.…Once that's been done, I return to the Backstage view and back to Save & Publish.…I would put in the address of the SharePoint Server.…
- 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.