DataExpress Information


FMS homeDatabase Reporting Home

HelpGet help downloading files.

On This Page

Reference Manuals and Training Guides

Training guides used in SBCTC-ITD DataExpress classes are available below for downloading. Interested college staff can download these training guide files and use them as self-paced training and reference materials at their own workstations. Note: screen representations included in these materials may not match exactly what you see on screens while in DataExpress. Also, when you are using DataExpress, you can access only those application and system databases to which you have campus authorization

Document Title/Description Last Updated
(mm/dd/yyyy)
Basic DataExpress for SMSPDF 04/01/2002
Creating DataExpress ProceduresPowerPoint 05/01/2002
Creating DataExpress Reports that Link FAS and SMS DataPDF
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 SubfilesPDF
Use this training guide to learn how to create reports that are the result of running two or more DataExpress procedures. When creating these multi-pass procedures, you can set up files of data that 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.
05/01/2009
DataExpress Administration Guide from M.B. FosterPDF 05/01/2004
DataExpress User Reference Manual from M.B. FosterPDF 09/01/2004
Level II DataExpress Workshop Training GuidePDF
The purpose of this training guide is to provide instruction on advanced DataExpress topics. This guide addresses such issues as Writing multi-pass procedures; Linking across applications; Accessing KSAM and MPE files; Uploading data, Report formatting.
11/01/2009
Share System Manaul: Using the Share SystemPDF
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).
04/01/2011
Share System Contact ListExcel 01/13/2014
Using DataExpress with FMS Customer Accounts and Subledger Data - LevelPDF
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.
11/01/2009
Using DataExpress with PPMS Data - Level 1PDF
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.
11/01/2009
Using DataExpress with SMS Data - Level 1PDF
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.
11/01/2009

Top of page

DataExpress Exercises and Examples

Document Title Last Updated
(mm/dd/yyyy)
Arrays, String Functions, and ComputationsPDF 10/22/2002
DataTypesPowerPoint 01/08/2003
Exercise: Array Field Extraction ComputationPDF  
Exercise: Comparisons in Computations and Selection CriteriaPDF  
INFORM.PLIB OverviewPDF 01/08/2003
INFORM.PLIB User Notification ProcessPDF  
Modifying an Existing ProcedurePDF 08/14/2002
SMS Overview and ExercisesPowerPoint 10/22/2002
UDALink Reporter for LGBTQ pdf 10/15/2013
Using the Summarize By FunctionPowerPoint 01/08/2003
Using The Unusual Action Code DatasetPowerPoint 01/08/2003

Top of page

Frequently Asked Questions and Tips

Document Title Last Updated
(mm/dd/yyyy)
DataExpress FAQsPDF  
DataExpress TipsPDF 07/28/2014
File Type Q & A PDF 10/21/2002

Top of page

Page Manager: phruska@sbctc.edu
Page Reviewed/Updated: July 30, 2014, 1:29 PM

The Content box should not go past this line

WA State Board for Community and Technical Colleges  |  Open 8 AM - 5 PM, Mon-Fri  |  Phone: 360-704-4400  |  Fax: 360-704-4415

PO Box 42495  1300 Quince Street SE  Olympia, WA 98504-2495  |  Get Directions  |  Contact Web Master