Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
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.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 74494 Viewers
80 Video lessons · 129709 Viewers
52 Video lessons · 63944 Viewers
59 Video lessons · 49729 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.