Start learning with our library of video tutorials taught by experts. Get started
Viewers: in countries Watching now:
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.
Microsoft Access's Ribbons allow you to create and work in your database quickly and easily, but sometimes they can take up valuable screen real estate. You have the ability to expand and collapse your Ribbons as needed. To do this click on this chevron- shaped arrow in the upper right corner next to the Help circle. The Ribbon collapses so you can see more of your data leaving just this row of tab names. Click on anyone and the Ribbon expands so that you can select your command. When you're done the Ribbon collapses again, when you want the Ribbon back simply click on the chevron arrow and it will reappear.
Another way to do the same thing is to right-click anywhere on the Ribbon and then choose Minimize the Ribbon. I can right-click on any of the tabs to get that command back, to unselected. A third way to expand and collapse the Ribbon is to double-click on any of the tab names, the tab appears, the tab disappears. And last use the keyboard command Ctrl+F1 to toggle it, open and close. I'm going to go back to the Home Ribbon and change back to Datasheet View.
When you have a lot of data to view at once, collapsing the Ribbon will gain up to an extra inter-real-state on your screen.
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.