Details

Goals

Be able to create query to display and edit data. 

Prerequisite

Know about relational databases.

Contents

Select queries 

  • Create a query to retrieve data from a single table 

  • Create a query to retrieve data from multiple tables 

  • Set a query’s criteria 

  • Create a parameter query 

  • Create a calculated field in a query 

  • Create groups and aggregates in a query 

Action queries 

  • Create an append query 

  • Create a delete query 

  • Create an update query 

  • Create a make-table query 

Create a crosstab query 

Sign up

Next session(s)

This training is exclusively on request. Contact us to get a personalized offer.

Sessions available in

Need a custom training?

None of the trainings fit your requirements? You have specific needs? Key Job trainers are versatile and flexible. Contact us!