Print PDF
Print Course Overview

Bookmark and Share

Microsoft: Access

Microsoft Access Training CourseAccess is a great tool for database development if used correctly. PCS has a dedicated Solutions team that provide commercial systems for many international clients. Utilising the knowledge and skills of our PCS Solutions team we offer 5 stages of training which will give you the tools you need to be able to quickly master this industry standard database application.  View Microsoft Access Subject Details

Stage 3: Queries And Reports ITD06

Scheduled Training Courses

 24/05/2012  22/06/2012  24/07/2012  22/08/2012  24/09/2012  23/10/2012  22/11/2012

This Training course can also be run on request as a One to One or a Classroom Booking.

Overview

This course is aimed at users that have attended the previous stages or who are very experienced and understand Primary and Foreign Keys (1 to Many). This course is perfect for people needing to question, append, delete data and produce professional reports on an existing database.

  • Type (Select/ Delete/ Append/ Make Table Query/ Crosstab)
  • Total Command (Group/ Average/ Sum/ Count/ Max/ Min)
  • Find Duplicates & Amending Existing Broken Queries
  • Multiple Table Queries (Converting Into A Flat File Mail Merge)
  • Reports (Multiple Tables & Queries Reports)
  • Summarise Reports (Group & Totals)
A Multi-table Query linking Actors to Films

Related Training Courses

Stage 1: Inside Access ITD04
Stage 2: Relationships ITD05
Stage 3: Queries And Reports ITD06
Stage 4: Forms that Work ITD07
Stage 5: Access Masterclass ITD08

Find Training Courses

Search The Pringle PCS Training Brochure View All Training Courses

Book This Training

CALL 0114 281 3350

Or email us

sales@pcs-limited.com

Single Booking £175.00

£105.00 40 % Discounted Price
Normal Price £175.00
* Discounts Apply When Booking More Than One Person On The Same Scheduled Course ex vat  
One delegate in a mixed group at Skywalker House

One To One

Price £395.00 ex vat  
One delegate one trainer either Skywalker House or at your premises
* Rates may vary for training at your premises if your premises are over 70 miles from Skywalker House

Company Classroom

Price £445.00 ex vat  
A dedicated trainer for your company either Skywalker House or at your premises
* Rates may vary for training at your premises if your premises are over 70 miles from Skywalker House