Upon Request Courses

Access Advanced Query Design

This course takes an in-depth look at creating advanced queries in Access. Learn how to create expressions to combine and split data, use queries to change table data and create outer joined queries, summary queries, parameter queries, and SQL queries.

Dates & Times

Request

Call (518) 786-1181 or contact us for customized, individual or group training.

Course Outline

Corporate and NYS discounts do not apply for this course.

This course is recommended for individuals who currently write Access queries and want to learn the advanced features and techniques available to make truly powerful queries in Access.

Includes:
Comprehensive reference manual, covering advanced querying topics and beyond
Access to participant data files
Follow-up support by email or phone for an unlimited period

Lesson 1: Building Expressions

  • Using Mathematical Operators
  • Using Dates in Calculations
  • 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