Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
The first query we're going to make is called a Select Query. That means we'll want to see some but not all of the fields in the table. We'll use the Query Wizard to do this. To start, click on the Create tab, and then on Query Wizard. In the dialog box, we want a Simple Query Wizard. Click OK. So let's say you want to make a Phone List for your Sales Reps. Drop down the Table and choose SalesReps. Click on LastName and move it over, and FirstName and move it over, then HomePhone, CellPhone and Email. But wait.
Maybe you decide that you'd rather see the CellPhone first. Move these three over and then click on CellPhone, HomePhone and Email. Go ahead and click Next. Enter in the Query Name. We're going to change this to Sales Reps Phone List Query. It gives you the option to either run the Query or open it up in Design View to further edit it. We want to run it, so just click the Finish button.
You now have a complete list of all your Sales Reps and their contact information. You can double-click on the columns to resize them, and then let's close it and save it when it asks. Now, we see Queries with our Sales Reps Phone List Query on the Navigation Pane, and I can double-click on it to run it anytime to get a complete up-to-date list of my employees. Later, we can use this Query as the source to make a printed report.
The Query Wizard and Select Queries make it easy to pull out just the fields you want to see.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 70034 Viewers
80 Video lessons · 127428 Viewers
52 Video lessons · 62369 Viewers
59 Video lessons · 48073 Viewers
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.
Your file was successfully uploaded.