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

 
 
 Queries I: Get started with queries 
 
  Overview  
 Show/Hide lesson sections Get started with 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.

Bookmark and ShareShare
Overview
Retrieve data with queries  

Learn how to create queries. Queries retrieve information from your database, and they can also do some heavy lifting, such as calculating the sales figures for last quarter, or finding just the right set of customers in France.

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

  • Length: 20–25 minutes
 


GOALS

After completing this course you will be able to:

  • Design a select query.
  • Run select queries.
  • Open a select query in Design view.
 
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

Once you get your data into your database, how do you get that information out again? With a query.

Queries are what you use when you need to compare weekly sales figures, track packages, or find all the members of your club who live in Texas. In other words, they're how you answer questions, and that makes queries an essential databasing skill.

This is the first course in a series that explains how to create queries. We'll introduce you to the types of queries that you can create in Access, but throughout the series, we'll focus on using the most common type of query, called a select query.

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

You must be familiar with the basics of database design, tables, and relationships. If you aren't, take these preparatory courses, and then return to this course.

  Go to previous page (disabled)    Next Go to next page
advertisement