Microsoft Access 2010 Tutorials
Accessing Your Data / Using the Query Wizard
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 / Accessing Your Data / Using the Query Wizard)
The simplest way to build a query in Access 2010 is to use a tool called the Query Wizard. Now I've opened our Lesson City database, and if you'll notice that I have an Instructors table, a Students table, and then I've got a couple of kind of junk tables that I've built doing little demos, and we'll get rid of those later. But for now, let's talk about using the Query Wizard to just get some simple data out of our Students table. If I go to the Create Tab up here, and you'll notice the Tabs across the top, but if I go to the Create Tab on the Ribbon, under the Queries Section, you will see Query Wizard. A simple left-click on the mouse opens up the Query Wizard and you will notice that I have four choices now. I can do a Simple Query, a Crosstab Query, a Find Duplicates Query, or a Find Unmatched Query. What I'm going to do is demonstrate this on the Simple Query Wizard, the kind of help you get comfortable with how this thing's thinking, and asking you questions, and I'll just click OK. And the first thing it does is ask me, OK, what table do you want to pull data from? Now it's doing Students because I had Students selected when I clicked on the Query Wizard icon. But I can change that easily by hitting the drop-down and switching over into Instructor. And notice when I did it displayed the fields in the Instructor table, so let's go back to Students. Notice, here they are. Now these are all the available fields in the table, and on the right here are the ones that I'm going to select out using the Query. And so what I'll need to do is choose a column, or a field name, and click on the right arrow. Now if I want to put all of these over here, just simply click on the double arrow and everybody jumps over, or I can move them back and I can just click first name, hit the arrow. Notice last name stays highlighted and I can hit that. Or, let me push them all back again and show you the easiest way to do this. Just double-click each column. So I double-click to first, last, and age, and I put them in place there, and you can see that I have my three columns, and now I'll just hit Next. Let me back up and show you one thing, by the way, before I leave that. Let's do that again. What if I wanted to show age first? Just click it first and then do first, last, and notice I did street by accident. So I'll back that up and do last name, OK? Let's take them back, first, last, age. Now I'll hit Next. Now I have a choice. I can do every field of every record, or I can do summary. And if I do summary, notice I can choose Options, and it looks at fields that can have mathematical actions done on them and it only sees the age field as a Number Type, and I can get a Sum, an Average, a Minimum, a Maximum. I can just choose these and get that. Then I can also tell it to count the records in Students if I would like. Well, I'm going to cancel that and I'll just run the detail. You can play with that later on your own. I'll click Next and you'll notice that it is going to call this Students query, and I'm going to take the space out. And actually, let's just change that to Students Age, and notice I can open the query to view information, or I can modify the query design. Well, what I'm going to do is open the query, or execute the query, and I click Finish, and it ran my query, and there you go. There's the first name, the last name, and the age of everyone in the table. And you'll notice over here to the left, it saved Students age and so now if I close this and later come back and double-click Students age, it gives me the query. So, that's the Query Wizard. Now run that thing a few times and play with some of the possibilities there. We'll come back and look at Crosstab a little bit later on and might play with a few others, but that's roughly the Query Wizard. Now this gives you the simplest of functionalities for your queries and in separate videos we're going to talk about the Query Design View, and then just writing our queries, just writing them out in SQL code, just from a blank screen. So, that is the Query Wizard.
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
