Menu
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