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.
Power users do as much of their work as they can with their hands on their keyboards instead of continually reaching for a mouse. For frequently used commands using KeyTips will really make those precious seconds add up. Let's say I want to add a new table in my existing database. To do this using KeyTips, press the Alt key on the left-side of your keyboard. Little letters will appear over each of the ribbons, and a 1, 2, 3 will show up on the Quick Access toolbar. Some of the letters are the first letters of the ribbon name.
Context-sensitive ribbons like the Table tools will always show up with a J as the first letter of those tabs. So to create a new table I've to go to the Create Ribbon. So I'll press C on my keyboard, the Create ribbon appears and there is a T+N under the Table button that I want. So I'll type TN, a new table appears. If I want to add a number field to my table, I'll press Alt on my keyboard again J+B to move to the Table tools fields ribbon, and then D+N to choose a number field.
I'll enter a field name, Quantity. To save my table I'll hold down Alt and press 1. Since this is a new table Access's ask me to name it, I'll call it Inventory. And because the OK button is blue all I have to do is hit Enter on my keyboard, I don't even have to click on it. In this way I can get a lot of developmental work done in just a few keystrokes, without even taking my fingers of the keyboard. Do you know, that KeyTips and keyboard commands are not exactly the same thing.
We'll cover keyboard shortcuts in a future lesson.
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.