Start learning with our library of video tutorials taught by experts. Get started
Viewers: in countries Watching now:
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.
While Access 2007's Office button brought together all the commands for the program itself, the new Backstage view organizes this information into a File menu. As soon as you open up Access you immediately notice that the File menu is back on a new red tab before the Home ribbon. Save, Open, and Close are all right on top. And you finally have the ability to easily do a Save As for your entire database to rename it or to move it to a new location. Here are your recently used databases, so when you click on it, it will open right up.
I'll go back to the Backstage view again. The Info button gathers together information and tools particular to your database. It's dynamic and will change according to your database. Sample tools that may appear here include SharePoint publishing services, relationships, Compact & Repair database analysis and encryption. The Recent button shows you your recently opened files. And down here you can specify how many you'd like to see. The New button arranges your templates into groups.
For example, I'll click on Sample templates and see all the templates that come with Access. One of the challenges with Access has always been that you have to know how to use a database in order to use the program. The addition of so many new templates makes Access more accessible. The Print is exactly the same. Save & Publish allows you to convert the database to previous formats. You'll also find Advanced tools to publish your collection as a standalone application or on a SharePoint server.
And if you are publishing on the Web using SharePoint here is Publish to Access Services and all your settings. Help has been brought down to this menu as well, as well as Access' Settings andOptions. The new File tab and the Backstage view will feel more familiar to long time Access users who missed having a traditional File menu.
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.