Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
You can customize the ribbons to enhance your workflow by creating ribbons of your own with your most frequently used commands. In the File ribbon under Options choose Customize Ribbon, click on the New Tab and it'll create a new ribbon with a New Group underneath it. I want to move this to the end, so I'll click on it and I'll hit my down arrow until it's at the bottom. I'm going to call my new tab Alicia, so I click on it to turn it blue, click the Rename button and type the new name, and I'm going to call my new group Frequent.
I could also choose an icon for it, but I'm not going to do that right now, I'll click OK. Now it's time to choose commands for my ribbon, I'll click on the group where I want them, I can choose from Popular Commands, All the Commands in Access or even Commands that are not on any ribbons. I want to go to All Commands and I'm going to choose these in the order I want to see them. I'm going to start with Application Parts, so I'll click on it down here in alphabetical order and add it to my ribbon.
Next, I want the Form Wizard, so I scroll down to the F's, find Form Wizard and add that to my ribbon. And now I'm going to scroll down to the O's and find Open Recent File. You can of course choose any command that you'd like. Now that I have my ribbon and my first group, I'll click OK and let's go see it. Here is my Alicia ribbon; here are my first three buttons.
What's neat is that this is not just for frequently used commands; you can use this technique to create your own sets of ribbons for your database, turning it into your own customized application. Modifying the ribbons makes you work in Access as efficient as possible.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 74751 Viewers
80 Video lessons · 129846 Viewers
52 Video lessons · 64048 Viewers
59 Video lessons · 49842 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.
Your file was successfully uploaded.