Create queries for a new database

Learn how to create database queries Learn how to create queries for an Access database. Queries are an essential part of any database. They’re how you answer extract meaningful information from your database and answer key business questions. This is the fourth course in a series that teaches beginners how to use Access 2010.

Start course button

About this course

This course includes:

  • One practice session for hands-on experience. The practice requires Access 2010.

  • A Quick Reference Card you can print at the end of 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 and 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 an expression to concatenate fields.

Before you begin

Topics in this course

  1. Get answers from your data

  2. The basics of creating select queries

  3. Ways to use query results

  4. Query a single record source

  5. Make a query ask for input

  6. Use a formula in a query

  7. Query multiple record sources

  8. Practice

  9. Quick Reference Card

Applies To: Access 2010



Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Support resources

Change language