Join Alicia Katz Pollock for an in-depth discussion in this video Exploring Backstage view, part of Access 2010 New Features.
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.
- 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.