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.
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.
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.