Page 1 of 11PREVNEXT

Create queries for a new Access 2007 database

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.

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.

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.

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


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.

Page 1 of 11PREVNEXT