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.
One of the bonuses of creating relationships is that you can then see sub data sheets within your tables, without to having run a report. Open up your SalesReps table, notice the Plus sign to the left of my data, click on the Plus sign, next to Jordan Hinton and you'll see all of his customers, then click on the plus next one of his customers and you can see all of that customer's orders. It would be handy to get some statistics on these orders, click on the Totals button up in the ribbon near the center.
Now a new Total row opens and you can click at the bottom of each cell to get a dropdown that has a number of different statistics that you can see for each order, this totals rows is covered in detail and the totals video in the course, click on the Minus sign to close Avulon. Now here's a slick trick, this gray box in the corner of the sub datasheet allows me to expand or collapse all of the sub datasheets at that level, let me show you how it works, click on the gray box and you will notice that the whole thing turns blue, then click on the Plus sign and not only does Avulon open, but I can see all of Jordan's customer orders complete with the total row, if I turnoff total row it'll disappeared from all of them and if I click back on that gray box again, I can now collapse all of them all at once with one click.
Using these sub datasheets gives you a convenient quick glimpse into how you data flow in your hierarchy.
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.