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 2007 Query Design

Understand and create all query types in Access 2007.

Recommended Preparation: Access 2007 Basic or equivalent experience.

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

Lesson 1: Revisiting Table Relationships

  • Using relational databases
  • Understanding join types
  • Understanding referential integrity

Lesson 2: Creating Select Queries

  • Querying from related tables
  • Finding unmatched records
    Using criteria
  • Using subqueries
  

Lesson 3: Using Calculations in Queries

  • Creating calculated fields
  • Using the expression builder
  • Adding grouping and totals
  • Concatenating fields

Lesson 4: Additional Query Topics

  • Using Pivot Table queries
  • Using parameter queries
  • Displaying top values

 

 

Dates:
August 4
8:30-12:15

October 6
8:30-12:15

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

Length:
4 Hours

Quick Links

Request information

Register for a class

Get follow-up support

Create a My MicroKnowledge profile

Get Directions