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.
Power users know that right-clicking on your mouse on almost anything on your screen will give you a context-sensitive shortcut menu. This allows you to invoke frequently used commands without having to move your mouse very far around your screen. What right-clicking does depends on what you click on. If you right-click on the Quick Access toolbar, or a Ribbon tab you get commands to manage them. If you right-click on a button itself you can immediately Add something to the Quick Access toolbar. If you right-click at the top of the navigation pane you get options for viewing and sorting your Tables, Forms, Queries, and Reports.
If you right-click directly on one of your objects in the navigation pane here you can Open it and even choose the View. Import and Export data from them, use the E-mail Collection with Outlook, Rename the object, Hide it, Delete it, Cut it and Copy it for duplication, see its Properties, and check its Compatibility on the Web. I use open in Design View a lot. If you right-click on a field name you can Sort the column, duplicate the column, change it's Width, Hide and Unhide it, Freeze and Unfreeze it, and we'll cover both of these in detail in future videos.
You can also Insert new Fields, Rename the Field, or Delete the Field. If I right-click directly on some of the data in the table I can Copy and Paste it, Sort it, and even Filter it. For example, I can filter right from here and find all of my customers that are in Nevada and if I right-click again on it I can Clear the filter. Here is when most people don't think about. If I right-click directly on my scrollbar, I can jump to my Top and Bottom, Page Up and Page Down, Scroll Up and Scroll Down, or even use Scroll Here to jump to an exact location.
And if I right-click in the Search box at the bottom I can paste in information to search for. For example, maybe I will get some information from another application I can come straight down to my Search box, right-click on it, Paste, and jump straight to that data in my database. If I right-click on the Status bar at the very bottom I can turn on and off different one click shortcuts. And last, but not least if you have a mouse with the middle button or scroll wheel sometimes that will act as a shortcut as well.
For example, I can go up to my object tab click on my scroll wheel and it shuts. If you become a right-click master you'll save yourself a lot of time with essential functions at your fingertips.
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.