Microsoft Access 2010 Tutorials
More Cool Access Stuff / Pivot Tables & Charts
Visitors to VTC.com will be able to view all introductory videos for each training course.
Free Trial Members will gain access to first three chapters for each training course.
Full Access Members have full access to VTC.com�s entire library of video tutorials.
Learn More
Subtitles of the Movie (Microsoft Access 2010 / More Cool Access Stuff / Pivot Tables & Charts)
The ability to use Pivot Tables and Pivot Charts in a couple of places in Access is way past cool if you ask me, and these things always, first of all, impress the people that you provide this information to, but it is just a great way to drill into your database, and slice and dice your data and see exactly what you got, and, and what the data is really saying and turning that data truly into information. So enough jabbing about it, let me go in here, and show you this thing. Well if I take the student instruments query, and I'll double click and run it, so that you see what we get. Same one as I've used in a couple of other examples. We get instruments, the City the students from, the age of the student, and the students name. If I right click and go into Design View, you know, I'm going to get it the same old way, and if I run it, this is what it looks like, but notice I can go into Pivot Table View, now this is really cool. Very much like a Cross Tab, but even more powerful here. Notice I am going to grab instrument, and just drag it to the left, and drop it on the row field, it'll take it just a second to get it all calculated and laid out, and there it is. Then I will take the City, drag it to the top, and wait for that to calculate up, and then I will take the age, and drag it into the value, the totals, or detail fields here. And notice what I just got, OK? Now I can tell it to hide details, or show details, and I can click on these little minus signs here, and the plus signs, to start to see things. But notice it's showing me that, in Brentwood, I have the average age where I have the age of seventeen year old playing the drums. In Nashville, I have a 70 year old, and a 42 year old, and you can kind of work that out. But watch this. I can right click on my age column and go to Auto Calc, and say, give me a count of these. And notice what it's going to do. It is going to drop a count in here, and if I Hide Details now, notice it hid the details as far as the actual age, but it's still leaving me the count of the age, and my grand totals are working for me, OK? So this is adding across to get here, you can see how it's working, and then this is adding down to here, and this one is adding down to here, and so is this one, OK? And then by showing details, and hiding details, I can get back in here, and see what exactly what I need to see. Notice I clicked on guitar, show details, drums, show details, and then notice I can take Fairview out, and come back in, and I can filter these things. I can drop a filter up here and do this, and if I decide I don't like the way these things are laid out, I can just move them around OK? I'll take instrument up there, notice how that's doing it by the way? Here's everybody in Brentwood, here's everybody in Nashville, then I would have to scroll across, well I've got Fairview taken out, so I'll put them back in, but you see what I'm doing with the data here. You can just move your data around, and slice it, and figure out exactly what you want, and then I can pull my instrument back down on this side, to see exactly what's going on. So that is a Pivot Table, that's a Pivot Tool, a Pivot Table View. You can also do a Pivot Chart View, and this is something else that's really cool. Notice here, that is that same data in a chart mode alright? So I can start to move these things around, OK? I've got count of age over here, and I have instrument down here, but what if I drag City over here next to instrument on the right side, notice how this shows me drums, this is Brentwood and Nashville, here's the guitar in all those places, but I can also take City and drag it in front of instrument, and flip these down here. OK? And so you can see the way it's, it's grouping them. Now it's grouping them by City, and then instrument, and this way it's going to group it by instrument and then City. So this is just another way that you can slice your dice. You can build really cool charts and so forth, and then you can save those things and use them. But Pivot gives you a lot of control and a lot of very visual type things that some people just really grab onto this. It can be kind of confusing at first, but again the trick, play with the data that you have, and that you know something about, OK? And you will do just fine with this. So that's Pivot Tables. Now you can also, let me close this out, and say No. But when you create forms, you can also create Pivot Tables and Pivot Charts as forms as well. So you can go play with that and see how cool that is. But I just wanted you to see Pivot Tables, Pivot Charts, and see the power of drag and drop in visualizing your data. This is a way to really pull some information out of those data tables.
Tutorial Information
| Course: | Microsoft Access 2010 |
| Author: | Mark Long |
| SKU: | 34224 |
| ISBN: | 1-936334-91-7 |
| Release Date: | 2011-05-12 |
| Duration: | 9 hrs / 121 lessons |
| Work Files: |
Yes |
| Captions: | No |
| Compatibility: |
Vista/XP/2000, OS X, Linux QuickTime 7, Flash 8 |
VTC Sign up & Benefits
- Unlimited Access
- 81,350 Video Tutorials (14,200 free)
- Video Available as Flash or QuickTime
- Over 715 Courses
- $30 for One Month Access
- Multi-User Discounts Available
