The third video lesson in this Access tutorial series. You will learn:

Queries:
1. What Does a Query Do?
2. Using the Simple Query Wizard
3. Designing Queries
4. Joining Tables in a Query
5. Adding Criteria to the QBE Grid
6. Running A Query
7. How is Using the QBE Grid Writing SQL Code?
8. Sorting Query Results
9. Hiding Fields in a Query
10. Using Comparison Operators
11. Using 'AND' and 'OR' Conditions

Advanced Queries:
1. Using the 'BETWEEN...AND' Condition
2. Using Wildcard Characters in Criteria
3. Creating a Calculated Field
4. Creating 'Top Value' Queries
5. Function Queries
6. Parameter Queries

Advanced Query Types:
1. Make-Table Queries
2. Update Queries
3. Append Queries
4. Delete Queries
5. Crosstab Queries
6. The 'Find Duplicates' Query
7. The 'Find Unmatched' Query

The best Access tutorial available:

- Designed by software training professionals.
- Learn at your office or home - at your own pace.
- Comprehensive! Includes all of the topics covered in a two-day classroom training.

For 2003, 2002 (XP), 2000 & 97.

The DVD purchase of this download contains all Mastering Access downloads.