Create queries for a new Access 2007 database
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 Quick Reference Card you can take away from the course.
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.