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

 
 
 Create queries for a new Access 2007 database 
 
  Overview  
 Show/Hide lesson sections Get answers from your data
  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
Learn to create queries  

Learn how to create queries. In Access 2007, you use queries to extract data from your database, and to provide data for forms and reports.

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

  • Length: 15–20 minutes
  

Next

GOALS

After completing this course you will be able to:

  • Use the Query Designer to create a select query that returns data from a single table.
  • Create a select query that asks you to enter parameters, then returns results that match those parameters.
  • Use a formula in a query to calculate a sum.
  • Use the Query Wizard to create a select query that returns data from two tables.
  • Use a text expression to concatenate fields.
  
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

So far in this series, you've designed and built the tables for an asset-tracking database, and you've created relationships that allow your tables to "talk" with one another. Now it's time to create queries.

Why queries? Because they're one of the most powerful tools in your database. For example, if you want to know how many computers you own, you can build a query to fetch that data and total the numbers. Queries can also provide data for your forms and reports, and that can help make your database easier to build and use.

This course introduces queries and explains how to create the most common type of query, called a select query. This course builds on the others in the series, but still assumes you're new to Access and databases.

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

Design tables for a new Access 2007 database

Create tables for a new Access 2007 database

Build relationships for a new Access 2007 database

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