Programming & Development

Access - Get Answers with Queries

Introduction:

This course is designed to provide a detailed look at queries in Access. Students will learn how to create different query types, joins, and criteria to extract specific data from their database.

Objectives:

Learn about Table Relationship types, Create Table Relationships, Understand Primary Key and Foreign Keys, Create Select Query, Learn Query Types, Append Queries, Update Queries, Delete Queries, Filter Criteria to a Query, Uncover Query Calculations, Create Query Totals, Modify Query Joins, Create Crosstab Queries

Course Outline:

  • Creating Table Relationships
  • Using Queries
  • Working with Query Types
  • Filtering a Query
  • Adding Calculations to Queries
  • Modifying Query Joins
  • Creating a Crosstab Query

Enroll in this course

$49.00

Need Help Finding The Right Training Solution?

Our training advisors are here for you.