Queries in Access

Intermediate

Understanding Queries in Access 2016 begins with learning how to ask simple questions about your data, like “how many?” and “which ones?” As you explore topics like relationships and referential integrity, however, you’ll learn how to select, update and delete records using queries. This class will also introduce you to the concept of joins and crosstab queries. As your experience grows during the class, more advanced features like the Query Wizard and Expression Builder will be introduced.

  • Asking the Right Questions
  • Different Types of Queries
  • Criteria and Parameters
  • The Expression Builder
  • Date and Time Calculations
  • Text Strings and Null Values
  • Action Queries
  • Interactive Queries

Class Length: 4 hours. Can include up to 15 attendees in one session.