skip to navigation skip to content
Mon 20 Mar, Fri 31 Mar, ... Fri 7 Apr 2017
14:00, ...
Venues:

Provided by: Student Systems


Booking

Bookings cannot be made on this event (Event is in the past).


Other dates:

No more events

[ Show past events ]



Register interest
Register your interest - if you would be interested in additional dates being scheduled.


Booking / availability

CamSIS Query Manager
Prerequisites

Mon 20 Mar, Fri 31 Mar, ... Fri 7 Apr 2017

Description

CamSIS Query Manager is a tool designed for administrative users to write their own queries in CamSIS.

Target audience

By invitation only. Not for students.

  • Further details regarding Student Systems' eligibility criteria are available
Prerequisites
  • Participants should have knowledge of the CamSIS interface, and an understanding of the data.
Sessions

Number of sessions: 4

# Date Time Venue Trainer
1 Mon 20 Mar 2017   14:00 - 17:00 14:00 - 17:00 University Information Services, Roger Needham Building, Ely Training Room 1 map John Hocking
2 Fri 31 Mar 2017   10:00 - 13:00 10:00 - 13:00 University Information Services, Roger Needham Building, Ely Training Room 2 map John Hocking
3 Mon 3 Apr 2017   14:00 - 17:00 14:00 - 17:00 University Information Services, Roger Needham Building, Ely Training Room 2 map John Hocking
4 Fri 7 Apr 2017   10:00 - 13:00 10:00 - 13:00 University Information Services, Roger Needham Building, Ely Training Room 2 map John Hocking
Topics covered
  • Tab Tour
  • Creating a query
  • Replacing a record
  • Select fields to display, fields display order and sort order
  • Changing heading text, and translating field codes
  • Adding criteria to filter the data
  • Prompts
  • Expressions
  • Aggregate Functions
  • Joins 1 – Record Hierarchy
  • Joins 2 – Related Record
  • Joins 3 – Any Record
  • Outer Join – steps
  • Outer Join - Belongs To
  • Subqueries - Checking for Existence
  • Subqueries - Single Value
  • Unions
Objectives

Delegates will learn how to use CamSIS Query Manager to write their own custom queries.

Aims

To be able to: Write new queries Edit existing queries

Format

Presentations, demonstrations and practicals

Duration

Four half-day sessions

Frequency

On demand

Related courses

Booking / availability