Penn State mark   AIS Header AIS Home Page link ITS Home Page link
in:
AIS Home > Data Warehouse > Sample Queries with MS Access Download > Previously Attending A Campus (SYSIF120)

Previously Attending A Campus (SYSIF120)

This database develops a query that will list students currently located at University Park, who previously attended another campus location.

STEP 1: Queries #1 - #3

While running queries #1 - #3, you will be prompted by an input box to enter the campus criteria in the two digit character format (e.g., BK, UP, AA).

STEP 2: Viewing Report

After running query #3 your results will be displayed.

* Note: Student number fields were excluded for privacy and security of student information.

Click on Download Here to download this MS Access Database



Questions: AIS Support


Printer friendly view



The Pennsylvania State University © 2008 | Copyright | Privacy and Legal Statements | Alternative Media - Nondiscrimination Statement
This site is maintained by Administrative Information Services, a unit of Information Technology Services.
Provide site feedback to AIS-webmaster@psu.edu. Can't find it? Ask AIS
Last revised: Monday, June 26, 2006 14:22