Microsoft Access: Queries - Advanced
Duration 0.5 days
Training Points 1.0
Team Professional Development

Learning Outcomes:

At the completion of this course you should be able to:

  • querying using multi-table queries

  • generating a parameter query to prompt for criteria

  • creating, editing and formatting calculated fields

  • summarising data in a query

  • learning how to concatenate fields together

  • developing aggregation queries to produce totals, averages, counts, etc

  • using action queries such as make-table, delete and append to manage the database

 

Pre-Requisites:

Participants must have attended the "Microsoft Access - Introduction" or "Microsoft Access - Simple Queries and Reports" course

 

Process:

Course Leader input, demonstrations, and hands-on practical sessions.

LocationStart DateAll DatesTimesPlaces AvailableBook