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.
Filter by Selection is the fastest way to locate Records in your Table or Form that match your criteria. Open up to your Customers form and let's say I want to see how many restaurants and stores I have in California. Find an example of CA in the State field, highlight it and then go up to the Home ribbon to the Sort and Filter group, find the Selection button and drop it down. I have four options, Equals "CA", Does Not Equals "CA" Contains "CA" and Does Not Contain "CA". I'll click on Equals California (Equals "CA") and now I can see that I have two customers in California.
To bring all my records back I can see the Toggle Filter is highlighted so I'll click on it, and now all my records return. Let's highlight California again and go back to that Selection button and this time choose Does Not Equal "CA"-- now you can see all of your customers except those in California, and I'll click the Toggle Filter button to turn it off again. I can also filter by partial fields. In the Company field I'll double-click on the word Deli and then go to the Selection button, now my choices are Contains "Deli", Does Not Contain "Deli", Ends With "Deli" and Does Not End With "Deli".
I'll choose Contains "Deli" and I can see that I have three stores that have the word Deli in the name. Filter by Selection is just one of a variety of ways to use Access's Filtered tools. Please see your Access 2010 Essential Training to see more of them in action.
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.