MicroKnowledge Inc.
Contact | Driving Directions | Home
Current Course Calendar
Quick Learn Sessions
Course Descriptions
Quick Learn Sessions
Basic Skills
Business Programs
Business Skills
Databases
Desktop Publishing & Graphics
Internet and Communications
Operating Systems
Presentations
Programming
Report Writing
Spreadsheets
Web Page Design
Word Processing
Customer Appreciation Training
Register for a Class
Customized Training
Proprietary Technology Training
On Site Training
About On Site Training
MobileKnowledge
Consulting Services
Technical Writing
Employment Opportunities
About Us
Site Map
Create Profile
Request Information
Support
Download Course Training Files

Access 2003 Advanced Query Design

Build criteria expressions, work with multiple tables, build advanced query types, use PivotTables, query with SQL.

Recommended Preparation: Access 2003 Intermediate and Access 2003 Advanced or equivalent experience.

Register for a class
Personalized training and consulting is available upon request.

Lesson 1: Building Expressions

  • Using mathematical Operators
  • Using dates in dalculations
  • Using text functions

Lesson 2: Using Action Queries

  • Creating tables with Make Table Queries
  • Combining records with Append Queries

Lesson 3: Relationships and Query Joins

  • Relational database fundamentals
  • Working with Multiple Table Queries
  • Creating Outer Joins
  

Lesson 4: Using Summary Queries

  • Creating a Totals Query
  • Grouping on Multiple Fields

Lesson 5: Queries with User Interaction

  • Running Parameter Queries
  • Using a Custom Form with a Parameter Query

Lesson 6: Querying with SQL Statements

  • Using SQL to Perform Select Queries
  • Using SQL to Create Subqueries
  • Using SQL to Create Union Queries

 

 

 

 

Dates:
March 26
8:30-4:30

Price:
$229 for open enrollment courses, when available.

Length:
8 Hours

Quick Links

Request information

Register for a class

Get follow-up support

Create a My MicroKnowledge profile

Get Directions