DataExpress: Manuals, Exercises and Tips

College staff can download SBCTC-ITD DataExpress training guides to use as self-paced training and reference materials.

Note: Screen representations included in these materials may not match exactly what you see on screens while in DataExpress. In DataExpress, you can access only those application and system databases to which you have campus authorization.

Expand All

Reference Manuals and Training Guides

Document Title/Description	Last Updated (mm/dd/yyyy)
Basic DataExpress for SMS	04/01/2002
Creating DataExpress Procedures	05/01/2002
Creating DataExpress Reports that Link FAS and SMS Data The purpose of this training guide is teach you how to create reports by extracting and combining data from the Financial Aid, Student Management and other databases. The manual includes information about what is included in each database so that you will know where to obtain the information you want. You can use these materials to create practice procedures that link data sets among the databases. The manual also includes reference information about the process flow for financial aid and a description of the cataloged DataExpress procedures that are available for financial aid.	05/01/2009
Creating Multi-pass DataExpress Procedures Using SD Files and Subfiles Use this training guide to learn how to create reports resulting from two or more DataExpress procedures. When creating these multi-pass procedures, you can set up data files you create yourself by using SD (self-describing) files and DataExpress subfiles. This training guide describes SD files, temporary files, DataExpress subfiles, and explains when to use each. You can use these materials to practice creating multi-pass procedures for each of the following: Using a KSAM SD file Using a DataExpress subfile Using a temporary file	01/19/2017
DataExpress Administration Guide from M.B. Foster	05/01/2004
DataExpress User Reference Manual from M.B. Foster	09/01/2004
Level II DataExpress Workshop Training Guide This training guide has instructions on advanced DataExpress topics and addresses such issues like: Writing multi-pass procedures Linking across applications Accessing KSAM and MPE files Uploading data Report formatting	02/15/2017
Share System Manual: Using the Share System Use the Share System to transfer files, such as DataExpress procedures and other system data files, from college to college. The documentation includes a user's guide (PDF) and a Share System Manager contact list (MS Excel).	01/19/2017
Share System Contact List	01/13/2014
Using DataExpress with FMS Customer Accounts and Subledger Data - Level 1 The purpose of this training guide is to teach you how to create reports by extracting and combining data from the Customer Accounts, Subledger, Point of Sale, Table 1, and Student Management databases. The manual includes information about what is included in each database so that you will know where to obtain the information you want. You can use these materials to create practice procedures that use data from the Subledger (SLEDG) database and from the Customer Accounts (CA) database. You can also learn how to link data sets in the Customer Accounts and Student Management databases in order to create procedures that combine data from both of these databases.	07/10/2018
Using DataExpress with PPMS Data - Level 1 The purpose of this class is to introduce you to the basic concepts of PPMS database structure and to teach you to create simple DataExpress procedures using PPMS data. This class covers database structure and terminology, in general, and information about the Employee database, in particular. In addition to learning the basic steps for creating a DataExpress procedure, you will learn how to create a computational field and how to obtain data from two or more data sets by linking them together.	05/21/2018
Using DataExpress with SMS Data - Level 1 The purpose of this training guide is to introduce you to the basic concepts of SMS database structure and to teach you to create simple DataExpress procedures using SMS data. This class provides an overview of DataExpress functionality and navigation. Output, sorting, summarization, and selection criteria are described in the training guide. You will also learn how to create computational fields and how to obtain and link multiple data sets.	07/10/2018

DataExpress Exercises and Examples

Document Title	Last Updated (mm/dd/yyyy)
Arrays, String Functions, and Computations	10/22/2002
Data Types	01/08/2003
Exercise: Array Field Extraction Computation
Exercise: Comparisons in Computations and Selection Criteria
INFORM.PLIB Overview	01/08/2003
INFORM.PLIB User Notification Process	11/01/2016
Modifying an Existing Procedure	08/14/2002
SMS Overview and Exercises	10/22/2002
UDALink Reporter for LGBTQ	10/15/2013
Using the Summarize By Function	01/08/2003
Using The Unusual Action Code Dataset	01/08/2003