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 Access Data entry form most of the time, you can have it open automatically when the program opens. To do this, click on the File tab to go into Backstage View, and then on the Options button near the bottom. In the left column click on Current Database, then look over on the right, you'll see Display Form. Click on the Drop-down menu and there is a list of all the forms in your database. I'll click on Customers Order Form and then click OK.
It says, You must close and reopen the current database for the specified option to take effect. We'll do that. I'll click OK. I'll close Access and I'll open it again from the Office button and then choose my file. There is my Customers Order Form, just waiting for me. Opening directly to my most used data entry forms, saves a step and precious seconds every time I use Access.
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.