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.
The most frequently used command in my arsenal will make you laugh. It's the Undo button. When I make a mistake, I don't want to have to fix the problem, I can just use the Undo shortcut to put it back the way it was before I botched it up. Undo is available by default on the Quick Access toolbar in all Microsoft Office Applications. Apparently, I am not the only one who makes mistakes. It's the arrow pointing to the left. The keyboard shortcut for Undo is Ctrl+Z which will soon burn into muscle memory. I have opened my Customers table and I have a store called Avulon.
But that looks wrong to me. So I change the u to an a and then I do the same thing in Oakland and then I hit the Tab key and then I realize that I really was correct. Instead of going back and to make the edits, I can just go up and click on the arrow or use the keyboard command Ctrl+Z and it will go back to the way it was but something that's works differently from Word and Excel, is that in an Access table, all corrections to one record, count as one undo step, because they are all done before the record itself has been committed to disc.
So even though I changed Avulon and its city, two changes when I went to Undo, it undid both changes. Let's see how these affects a form. I will open up my Customers Order Form and I will change it to Layout View. Undo also has ability to fix errors several steps back. I am going to make a few changes to some of these controls. I will resize a few of the fields. I will make some larger, I will make some smaller. Now to Undo those changes, I can click on the little arrow to the right of the Undo button.
I see a list of all the changes that I made and I can select one or few steps down. This allows me go back in time and Undo several steps at once. But note though, that this does not allow me to pick and choose off the list. I can for example, only change the company name. I have to undo all the work I have done since. If I change my mind yet again and I really do want the change, I can use the Redo button. The keyboard command for Redo is Command+Y. Because it's much easier to undo a mistake, then to go back and redo the work, Undo will be one of your most used commands and Ctrl+Z is my second favorite keyboard shortcut to use after Save of course.
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.