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 make good use of keyboard shortcuts to work without having to take their hands off of the keyboard and reach for the mouse. Access 2010's ribbons don't make it obvious how to do this, so here are something's that you can do. First many of the basic functions are standardized across Microsoft Office. So the commands you know from Word or Excel will work in Access too. Save, Ctrl+S. Open, Ctrl+O. Cut is Ctrl+X. Paste is Ctrl+V, and Print is Ctrl+P. If you're in backstage view hitting Escape will jump you right back to the ribbon you're on.
Ctrl+F1 will minimize the ribbon. Here are my favorite specific to Access. When I'm working in my data pressing the Tab key will move me from field to field and holding down the Shift key as I Tab will take me backwards. Ctrl+Up Arrow takes me to the first record and Ctrl+Down Arrow takes me to the very last record. If I'm entering a new data, holding down the Ctrl key and pressing the Semicolon will give you today's date. Holding down the Ctrl key and tapping the Quotation Mark will duplicate the data from exactly above.
Let's look at a few keyboard commands for working with controls on forms and reports. I'll open up my Customers Order Form in Design View by right-clicking on it. I'll click on my CustomerID field and hold my Shift key down to select the label as well. If I want to move the field normally I would use my Up and Down Arrow, but if you like find or control if you hold down your Ctrl key as you hit your arrows you'll nudge and find your increments for exact placement. Shift+Right Arrow and Shift+Left Arrow will increase and decrease the length of your control boxes.
To toggle on and off the Property Sheet press F4. These are just a very few useful keyboard commands, we'll mention more throughout this course. How do you find out about more keyboard shortcuts? Use Access's Help the little blue circle in the top right-hand corner. I'll do a search for Keyboard Shortcuts and press Enter here are my Keyboard shortcuts for Access.
As I can click on each of the topics it will open up and tell me all of the relevant keyboard commands. If I go up to the upper right-hand corner there is a Show All link which will expand all the topics and now I can scroll trough the vast list of all the keyboard shortcuts there are. I can then click Hide All and it will go back to the individual menus. Mastering keyboard shortcuts will allow you to get a lot of work done without having to constantly reach for the mouse.
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.