Join Alicia Katz Pollock for an in-depth discussion in this video Using the improved ribbons, part of Access 2010 New Features.
In Access 2010 it is now possible to customize your Ribbons, whether it's…changing the default Ribbons to your liking or creating brand-new Ribbons for…your own frequent commands.…First, let's take a look at the terminology that's used.…These Ribbons are called the main Ribbons and then when I go into work with…different objects, these Ribbons are called the tools.…So let's go ahead and make our own Ribbon.…I am going to go into backstage view using the File tab and we're going to come…down here to Options.…About halfway down, you'll find Customize Ribbon and it's broken into two sections.…
These are the potential commands for your Ribbon.…Over here you'll find the Ribbons themselves.…This drop-down menu shows whether you're working with the main tabs or whether…you're going to work with the tools tabs.…So we're going to come down here to the bottom and make our own new tab.…The first thing I am going to do is rename my tab.…So, I'll click on the New Tab itself, click on the Rename button and I'll call…
- 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.