2335

Access: Success with Queries

 

Understanding the “Workhorse” of Access

 

Suggested Prerequisites: Access Levels I and II

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. This course should ONLY be taken after Access Level I and Access Level II have been completed, or with the express permission of the course instructor.

Topics

 

Select Queries

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

Formulas

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

Query Properties

  • Displaying Top Values
  • Displaying Unique Values

Advanced Queries

  • Parameters
  • Join Queries
  • Crosstab Queries
  • Finding and Eliminating Duplicate Information
  • Self-Join Queries

Action Queries

  • Make Table
  • Delete
  • Append
  • Update

Basing Queries on Queries

The Next Step… Outputting Query Results

Access: Success with Queries
Tagged on:     
Malcare WordPress Security