 Let's say for example, I want to take a lot of data from the database this time. We actually do want to use that from access option Now this makes it a little easier. We can come in we can dig around the same way we did before just with a nicer Dialogue box we want to select our database Now one of the things I want to do is I actually want to select from multiple Files multiple data sections one of the things I want to do is I want to enable selection from multiple tables I do want to sort of have that ability to kind of connect my tables my data together like my companies and Every single one of those in their recent performance. So I'll go ahead and hit okay So this information where do I want this? Because I'm dealing with multiple tables that means I have multiple records and so I'm really actually looking forward to Working with a pivot table now I am going to change from my existing worksheet to D4 if you've skipped ahead You can see we're actually going to kind of use this space as a little selection slicer area and I'm going to go ahead and hit Okay Now right off the bat. We don't see too terribly much We're just seeing a pivot table not doing too much We want to go ahead and start to bring this information in so for example, I want to put my date in My rows so I can see now Sort of every year on a row by row basis on a day by day basis from here I want to go ahead and take my volume and I want to put it as a value I want to see how many of these we had Traded on a given day and I actually want to also see the closing costs for a given day That way I get to see sort of what everything was now It's a little bit some of some of those aren't very helpful. So I'm going to change them to date shares traded how many shares were traded on a given day and I'll go ahead and just call this closing value. That'd be a little easier when we start to get a little For skier with it if you will I don't need these grand totals right here So I'm going to go ahead and come into my design option. I'm just going to change grand totals and turn it off Nice simple easy. We're not adding anything together Now I want to go into my analyze tab that analyze tab again like we've seen in the past Allows me to insert a slicer that slicer is going to be allowing me to pick Different options to view from our data be our filter basically. I'm going to select that just care about title I only really want title to be the big guy So suddenly now I can see all of the different options I can see all the different stock up stocks. I can work from I'll go ahead and bring this down Just a little more and you can see now. I can Zero in instead of selecting all of my stocks. Maybe I want to look at just Huett Packard You can see I can see how much a stock was worth for really a five-day range or say for example Boeing or aluminum company America