Access 2003 - Action Queries and Advanced Query Options
      The "Access 2003 - Action Queries and Advanced Query Options" lesson covers the following topics:
  • Queries
  • Action Queries
  • Advanced Query Options
      
      Queries      
      Upon successful completion you will be able to:

1. Create Simple Queries;
2. Sort within Queries;
3. Use Grouping in Queries;
4. Join Tables;
5. Use Arithmetical Operators;
6. Use Logical Operators.
7. Use Wildcard Characters;
8. Create Top Values Queries;
9. Create Crosstab Queries.		      
      Action Queries      
      Upon successful completion you will be able to:

1. Understand Action Queries;
2. Create Make Table Queries;
3. Create Update Queries;
4. Create Append Queries;
5. Create Delete Queries;
6. Modify Existing Queries.		      
      Advanced Query Options      
      Upon successful completion you will be able to:

1. Understand Advanced Table Joins;
2. Create a Table Alias;
3. Create Query based Queries;
4. Use NOT and NULL Operators;
5. Create Parameter Queries;
6. Create Find Duplicate Queries;
7. Create Find Unmatched Queries.		      
This course can be purchased either individaully or as part of a package.
Single Training Course - Access 2003 - Action Queries and Advanced Query Options :
Program Training Courses - Microsoft Access 2003 :
Office Suite Training Courses - Microsoft Office 2003 :
© 2017 Online Training Masters