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.

See specific content information below in section and "Attend and You Will Learn."

 

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

Participants who successfully complete this course will receive a certificate of completion from NC State University

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 / Expected Outcome

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

Instructors

Loading...

Enroll Now - Select a section to enroll in

Section Title
Access Queries
Type
Online
Days
T
Time
9:00AM to 4:30PM
Dates
Oct 20, 2020
Schedule and Location
Contact Hours
6.0
Location
  • Off Campus
Delivery Options
Course Fee(s)
Standard Registration Fee non-credit $345.00
Instructors