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.
If you're designing your database for other people to use you'll find times when you'd like to provide them with instructions, one convenient tool utilizes Screen Tips and Status Bar info comments. Scroll down in your Navigation pane and open up the Customers Order Form. Notice when I hold my cursor over my Notes field it tells the user what to do, this is a screen tip, and if I click in the field and then look in the lower left-hand corner at the Status Bar, I can see instructions to follow. You can train your users to look in these two places when they have questions. Let's add a Screen Tip reminding the user that they don't have to type in the Parentheses and the Dashes when they enter in the phone numbers.
Click in the WorkPhone field, change the form to Layout View, this technique also works in Design View. Open up the Property Sheet by clicking on the button in the upper right-hand side of the ribbon, go to the Other tab. Here, where it says ControlTip Text, type in, Enter numbers only, then go down to the Status Bar Text field and key in, Access will automatically format phone numbers for you. Now, go back to the Form View, hold your cursor over the WorkPhone and it says, Enter numbers only.
When you click on it, look down below the Status Bar and it has your message, Access will automatically format phone numbers for you. Using Screen Tips and Status Bar Text can be an excellent training and help tool for you users, just make sure they know to look for these hints.
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.