Start learning with our library of video tutorials taught by experts. Get started
Viewed by members. in countries. members currently watching.
In Access 2010 Power Shortcuts, Access expert Alicia Katz Pollock shares hundreds of tips and shortcuts to vastly increase efficiency and get the full power out of Access 2010. The course includes tips for working with the Ribbon and Quick Access toolbar, managing files, customizing and automating Access, rapid data entry and editing, working with tables, queries, forms, and reports, managing your database, and much more. Exercise files accompany the course.
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.
There are currently no FAQs about Access 2010 Power Shortcuts.
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.