Start learning with our library of video tutorials taught by experts. Get started
Viewed by members. in countries. members currently watching.
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.
If you work on the same files on a regular basis, you can quickly open all your recent files without having to go find them in Windows, you can do this from several places. First in Windows itself, you can click on the Start button in the lower left corner, if you have used Access recently it will appear here on the Jump menu, hold your cursor over it and you'll see a list of the recent Access databases you've opened. If you like to keep one of these file on the list permanently, when you hold your cursor over that file, you'll see a little Push Pin on the right, click on it and a new section will appear at the top, that says Pinned.
These will stay here, even if they haven't been opened recently. To remove an item from this Pinned list, simply click on the Push Pin again and it will go away. You can do the same thing to Access itself, if I right-click on it I can Pin it to the Start menu and it'll appear here at the top above this line, even if I don't use it for a while. If I right-click on it again I can also pin it to the Task Bar. Now it'll appear down here and stay there even when the program is closed.
If I want to remove it from the Taskbar I'll right-click on it again and unpin the program from the Taskbar. Now let's look at your files from inside Access itself. Right here there is a short list of my recently opened files, if I go to the Recent menu, down at the bottom it says, Quickly access this number of Recent Databases, and this for refresh of the number of files that I'll see right here. If I don't want to see any at all I'll uncheck the box, I'll check it again to bring them back and I can increase this number if I'd like.
I can also see a list of recent databases right here on this menu and as you open new databases, they'll all start appearing with the newest ones on top. To control how many files show on this menu we actually need to go into Access's options. On the File Ribbon, down at the bottom there is Options; I'll click on Client Settings and then scroll down to where it says Display. Here it says Show this number of Recent Documents and I can increase this up to 50 or make it as small as I like, I'll leave it on 20 and click OK.
So now I want them on the Recent tab this will show me up to 20 of my most recent databases. Access makes it fast and easy to continue working on a file you've used recently or one that you use frequently.
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.