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.
You will use queries extensively to explore your data and you can visualize your data by turning your queries into pivot charts. Pivot charts allow you to interactively view your query results along two or more dimensions in a visual way. Let's start by understanding our scenario and our goal. I have opened my Orders table and it shows me by date what customer ordered what product, how many bottles, and their order status. And if I go over my navigation pane and down to Queries and I double-click on Order Totals, it now gives me all the same data, but it adds in the column at the end to tell me the grand total for that particular order.
When I look at it in Design View, I can see the calculation in the last column. But when I go up to the View button and I drop down the bottom half, I have some additional options. Let's take a look at the PivotChart View. When we choose it, a blank chart appears with placeholders. I have a field list here on the right. If your field list doesn't open, there's a toggle button up on the upper left-hand side of the grid. Pick up your product and drag it down to the bottom where it says Drop Category Fields Here.
Then drag Size right down next to it. You will see a little dark blue bar and I'll drop it. Now drag your Order Totals to the top header where it says Drop Data Fields Here. Now, you can see how many of each bottle you have sold. I can instantly see that my 32 ounce bottles of Light Olive Oil are far and away my bestseller. This new analysis will be saved right with the query. So once you saved it you can now switch back and forth between your views from Design View to Datasheet View to PivotChart View.
Look at the difference before and after. Creating a PivotChart from your query will allow you to do a visual analysis anytime making it easy to interpret your query results.
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.