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

 
 
 Queries I: Get answers with queries 
 
  Overview  
 Show/Hide lesson sections Put data to use
 Show/Hide lesson sections Create select queries
  Feedback  
 Quick Reference Card Quick Reference Card  
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.
Overview
Retrieve data with queries  

Find out how Microsoft Access queries enable you to answer questions and perform tasks with your data. Learn how to create a select query, the most common type of query.

  • Length: 40–50 minutes
  

Next

GOALS

After completing this course you will be able to:

  • Create a select query.
  • Refine a query in Design view.
  • Retrieve data that matches the criteria you specify.
  
ABOUT THIS COURSE

This course includes:

  • Two self-paced lessons and two practice sessions for hands-on experience.
  • A short test at the end of each lesson; tests are not scored.
  • A Quick Reference Card you can take away from the course.
COURSE TEXT

Once you get your data into your database, how do you get the data out again?

A database becomes really valuable when you use the data it contains as a resource to answer questions or perform tasks.

Whether it's comparing weekly sales figures, tracking packages, finding all the members of your club who live in Texas, or a multitude of other scenarios, a query can help you retrieve data and put it to good use.

To learn more about this course, read the overview in the center of this page or the table of contents in the left column. Then click Next to start the first lesson.

  
BEFORE YOU BEGIN

Before you begin

You should be familiar with the basics of databases and database tables, or you should take these courses: Get to know Access and Table that data.
  Go to previous page (disabled)    Next Go to next page
advertisement