Microsoft Access: Advanced Queries

Title:Microsoft Access: Advanced Queries

Duration:0.5 days
Training Units1.0
Central Short Courses

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 appendto 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 practicalsessions.



Book whole Programme
Location
Start Date
All Dates
Times
OtherTimes
Places Left
Tutor
Price
Funding can be used
 
 
 
 
 
 
 
 
 
 
 
 
 
 
There are no records available.