Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
Access 2010 gives you several ways of moving around the data in your tables and forms just by using your keyboard. Let's start with the simple stuff. Double-click to open up a table. When you press Tab you'll move from field to field across a record. If you hold down the Shift key as you press Tab what we call Shift+Tab, you'll move backwards to the records. Use your Up Arrow and Down Arrow on your keyboard to move up and down your records. If you hold down the Ctrl key when you use the Up and Down Arrows, you'll move to the very first record and to the very last record in your table.
If you hold down the Ctrl key while you press Page Down, you'll move across the entire record to the next screen. As you can see, the first time I press it I can see the entire store type and all the fields that come after. I notice that the Email Address is the next field that I see, and sure enough if I do Ctrl+Page Down again Email becomes my leftmost field and I can see the columns that follow. Ctrl+Home and Ctrl+End move me to the first and last fields in a record.
Now let's see how the same keyboard combinations work in a form. I'll scroll down and open up my Customers Order Form, Tab and Shift+Tab work exactly the same way, moving me from field to field and back. Now I'm tapping my Up and Down Arrows, they actually do the very same thing. Adding the Ctrl key, Ctrl+Up and Ctrl+Down take me to my first and last records. Ctrl+Page Down and Ctrl+Page Up move me up and down one record at a time.
Click in a field that has multiple words like your address field, Ctrl+Right Arrow will move me one word at a time and Ctrl+Left Arrow moves me one word back. If you want to copy here is a new trick if you hold down the Ctrl key and add in the Shift key and then hit your Right Arrow, you can now select a whole word at a time. Using these keyboard shortcuts allows you to move around your data without having to reach for your mouse at all.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 91279 Viewers
80 Video lessons · 138219 Viewers
59 Video lessons · 57046 Viewers
52 Video lessons · 70697 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.