Access Queries
CTU-ACCESS10QU-C

 Email this information to yourself or a friend

 Remind me of this course at a later date




Official Program Description

click here to jump to schedules and register

Queries are the "workhorses" of Microsoft Access. This course exhausts the query topics, giving the Access developer amazing tools to use when developing user-friendly, functional databases.

Who Should Attend

This course is designed for the Access user who wants to be totally proficient with queries.  All Access query topics are covered, and participants walk through great examples of each.  It is assumed that course participants have had Access Level 1 and Access Level 2 prior to taking this course.

Prerequisites

Students must have completed Access Levels 1 and 2 prior to attending this course; otherwise instructor permission is required.

Attend and You Will Learn

Select Queries

  • Sorting
  • Show Box
  • Naming Fields and Supplying Captions
  • Criteria
  • Boolean Logic

Formulas

  • Expression Builder
  • Summarizing Data Using Subtotals
  • Concatenation
  • Substring Functions
  • The IIF Statement

Query Properties

  • Displaying Top Values
  • Displaying Unique Values

Advanced Queries

  • Parameters
  • Join Queries
  • Find Unmatched Queries
  • Crosstab Queries
  • Find Duplicate Queries
  • Self-Join Queries

Action Queries

  • Make Table
  • Delete
  • Append
  • Update



Sections

  Access Queries
CTU-ACCESS10QU-C - 018
   
 
  2016 - TTS - Sep - Dec 2015   Status:  Available
 
In-Class:   Tue 9:00AM - 4:30PM
22 Sep 2015
Class Schedule: 1 Sessions
Contact Hours: 6.0
Course Fee(s):
Gov't & Non-Profit Registration Fee non-credit    $199.00
Registration Fee non-credit    $249.00
Potential Discount(s):
CTU-MultClassDiscount<249
  0.60 CEUs
Location:   On Campus
Instructors: Holly Sullenger
 
  Access Queries
CTU-ACCESS10QU-C - 017
   
 
  2016 - TTS - Sep - Dec 2015   Status:  Available
 
In-Class:   Thu 9:00AM - 4:30PM
19 Nov 2015
Class Schedule: 1 Sessions
Contact Hours: 6.0
Course Fee(s):
Gov't & Non-Profit Registration Fee non-credit    $199.00
Registration Fee non-credit    $249.00
Potential Discount(s):
CTU-MultClassDiscount<249
  0.60 CEUs
Location:   On Campus
Instructors: Holly Sullenger