Loading...

Course Description

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.

Related Courses

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.

Attend and You Will Receive

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

Prerequisites

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

Instructors

Loading...

Enroll Now - Select a section to enroll in

Section Title
Access Queries
Type
In-Class
Days
F
Time
9:00AM to 4:30PM
Dates
Feb 28, 2020
Schedule and Location
Contact Hours
6.0
Location
Delivery Options
Course Fee(s)
Standard Registration Fee non-credit $345.00
Instructors
Section Title
Access Queries
Type
In-Class
Days
Th
Time
9:00AM to 4:30PM
Dates
Jul 16, 2020
Schedule and Location
Contact Hours
6.0
Location
Delivery Options
Course Fee(s)
Standard Registration Fee non-credit $345.00
Instructors