Access Queries

Class length: 1 day
Hours: 10:00 am - 5:30 pm
Cost: $350



Xpress Workout: Access Queries

Workout Outline:

Next Scheduled Class:

Click here to request a
specific date for this class.

Onsite Training:

This class is available for
onsite training
. For more
information or to book
an onsite class, please
click here.

The visual representation of tables and the graphical links between them makes Microsoft Access
queries extremely easy to use. Fortunately, the simple graphical interface also allows very powerful
and advanced analysis. The entire query engine is modeled on SQL systems and allows switching
between the graphical query design and SQL syntax.

Knowing the many features of Microsoft Access queries will allow you to perform advanced analysis
quickly without programming knowledge. This presentation covers the basics of queries revealing
a variety of subtleties. It quickly moves to more advanced topics with hints and techniques for creating
sophisticated queries.

 

Course Outline:

 

Query Types

  • Select queries
  • Make table queries
  • Append queries
  • Update queries
  • Delete queries

Basic Select Queries

  • Selecting table and fields
  • Sorting and re-ordering fields
  • Renaming fields
  • Using calculated fields
  • Setting query properties

Setting Query Criteria

  • Multi-field query criteria
  • Criteria types
  • Nulls
  • Wildcard searches

Advanced Select Queries

  • Parameter queries
  • Using functions
  • Cross-tab queries
  • Multi-table queries
  • Basing queries on other queries

Action Queries

  • Make table queries
  • Append queries
  • Update queries
  • Delete queries

Using Queries in Forms, Reports, and Macros

  • Using queries in forms and reports
  • Running queries through Macros