MicroKnowledge Inc.
Contact | Driving Directions | Home
Current Course Calendar
Featured Micro-Sessions
Course Descriptions
Featured Micro-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
Free Events
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 Advanced Queries

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

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

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

Lesson 1: Build Criteria Expressions

  • Calculated column
  • Built-in functions
  • Expression Builder

Lesson 2: Work with Multiple-Table Queries

  • Relational database fundamentals
  • Types of relational models
  • Enforce referential integrity
  • Establish table relationships
  • Work with multiple tables in a query
  • Create other types of joins
  • Unique values query

Lesson 3: Advanced Queries

  • Totals query
  • Decision-making query
  • Parameter query
  • Action queries
 

Lesson 4: PivotTable Queries

  • One-dimensional PivotTable
  • Two-dimensional PivotTable
  • Filter PivotTable

Lesson 5: Querying with SQL Statements

  • Viewing SQL statement
  • Use SQL to perform a select query
  • Use SQL to perform action query

 

 

 

 

Dates:
December 22
8:30-4:30

February 10
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