Start learning with our library of video tutorials taught by experts. Get started
Viewed by members. in countries. members currently watching.
In Access 2010 New Features, author Alicia Katz Pollock explains each new and enhanced feature in Microsoft Access 2010. This course covers the Backstage view that replaces the File menu in Office 2010, shortcuts for building tables, new layout tools and navigation controls, the macro designer featuring IntelliSense, as well as exporting to and collaborating in SharePoint. Exercise files accompany the course.
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. I'd click this button and we'd be good to go.
There are several other places across Access where you use SharePoint publishing. When you create a table, you can start with a SharePoint Lists. When you import data, you can click on the More button and import a SharePoint list. When you're exporting, you can export a table as a SharePoint list. And in the Database Tools, there is a function for moving your data in and out of SharePoint. The improved data caching and synchronization tools will also ensure that if you're offline while working on your Access database, the files will automatically sync as soon as you do connect back up.
Hosting your database on a SharePoint Server makes it easy for you to publish content from your database to anyone in your organization and you can choose whether it's read-only, or if they can make modifications to your data.
Find answers to the most frequently asked questions about Access 2010 New Features.
Here are the FAQs that matched your search "":
Sorry, there are no matches for your search ""—to search again, type in another word or phrase and click search.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.