Access - Creating Queries

Price
$49.00
Duration
 One Hour
Delivery Methods
 VILT

 

Upcoming Class Dates and Times

Sep 26, 2022
8:00AM - 9:00AM Central
One Hour
Virtual Instructor Led
 GTR
Nov 22, 2022
3:00PM - 4:00PM Central
One Hour
Virtual Instructor Led
 GTR

Agenda

1 - Outline
  • Creating Table Relationships - Learn about the different types of relationships, primary and foreign keys, and how to create relationships. Using Queries - Learn how to create a select query to view specific data from your database. Working with Query Types - Learn how to use action queries to add, change, or delete data in your tables. Filtering a Query with Criteria - Learn how to use expressions in a query to filter the data retrieved with a query. Adding Calculations to Queries - Learn how to create fields using the expression builder and how to group data in a query to display totals in the query results. Modifying Query Joins - Learn how to change the join type in a query. Creating a Crosstab Query - Learn how to create a crosstab query to display a summary of your data.