Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
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 this Alicia's Commands. I'll click OK, and while I am at it, let's go ahead and rename my first group as well.
Now, whichever one I click on is the one where the commands will go on to, so I do need to add them to this group. It defaults to the Popular Commands, the most common things that you might do. Maybe it's opening up a file or maybe it's saving a table or the report that you're working on. I can also drop this down and get commands specifically from the main tabs. For instance, maybe I create a lot of queries. So I'll come down here and I'll grab both my Query Wizard and my Query Designer.
I can come down and go to the tool tabs as well. For instance, I like to do a lot of conditional formatting. So I'll go to the Form Layout Tools and to Format and then Control Formatting and I'll bring over Conditional Formatting, and then I am also fond of the themes. So I'll come over to Design and Themes and bring over my Themes. Let's take a look and see how this new Ribbon looks. I'll click OK and you'll see right up here, Alicia's Commands, and when I click on it, here are all of my favorite commands.
By customizing your own Ribbons, you can speed up your productivity and improve your workflow.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 99029 Viewers
80 Video lessons · 141744 Viewers
59 Video lessons · 60111 Viewers
52 Video lessons · 73254 Viewers
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.