Microsoft Office Online
Sign in to My Office Online (What's this?) | Sign in

 
 
Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Bookmark and ShareShare
Overview
Learn to create queries in Access 2007  

Learn how to create basic select queries. Select queries retrieve data from your database, and they're one of the most frequently used and versatile tools Access provides.

Don’t have the 2007 Office release? You can download a free 60-day trial or buy it now.

  • Length: 25–30 minutes
 


GOALS

After completing this course you will be able to:

  • Create a select query by using the Query Wizard.
  • Create a select query by using Design view.
  • Add criteria to a select query and filter your results.
  • Sort your results.
 
ABOUT THIS COURSE

This course includes:

  • One self-paced lesson and one practice session for hands-on experience. The practice requires Access 2007.
  • A short test at the end of the lesson; the test is not scored.
  • A Quick Reference Card you can take away from the course.
AUDIO TEXT

The first course in this series taught you the basics of queries — what they are and some of the ways you can use them. Now it's time to get your hands dirty.

This course explains how to create a select query, a type of query that retrieves and processes the data in your database. Select queries can be simple, but they're also versatile and powerful, and the type of query you'll use most often.

You'll learn how to use the Query Wizard and Design view to build queries. We'll also show you how to add criteria that filter your results, how to hide some of the data that your query returns, and how to sort data.

To learn more about this course, read the text in Goals and About this course, or look at the table of contents. Then click Next to start the first lesson.

 
BEFORE YOU BEGIN
  Go to previous page (disabled)    Next Go to next page
advertisement