Campus Specialized Class List for Selected Math Courses (SYSIF055) This set of queries reads the student and applicants databases and selects students enrolled in selected math courses which include Math 001, 002, 003, 004, 021, 022, 026, 030, 040, 041, 110, all 140's and all 141's for the designated course semester.  The FTCAP scores and all completed math courses and grades are printed on the report for each student. Start by selecting the CLICK HERE TO BEGIN button for instructions.   Next, select the QUERIES TAB, highlighting the first query, #1 - qry Create Campus Specific Student Listing.  Once this is highlighted, select the OPEN button to the right.   Once this query has run, continue to run the queries in the order they are listed.  If you are prompted to delete a table or paste rows into a table, simply answer "YES." You will also be asked for 2 sets of criteria throughout the process of running these queries.  You will be asked for campus code and current semester code.  The correct criteria can be found below.   For campus code, you need to enter the 2 character campus code: BD = Behrend (Erie) Campus OZ = Abington Campus UP = University Park Campus WS = Worthington-Scranton BK = Berks-Lehigh Valley For current student semester, you need to enter the 8 character semester code: 200001FA = Fall 2000 200001SP = Spring 2001 200001SU = Summer 2001 200001S1 = Summer 2001 Note: Query #2 is extracting information from the TCM table.  If you are running a report for a summer, when prompted for the semester on query #2, use S1 instead of SU. Once you have run the last query, select the REPORTS TAB, then highlight rptSYSIF055 and select the PREVIEW button to the left.  This will provide you with the actual SYSIF055 Report.   SAMPLE REPORT: This database is the following: Campus Specific Semester Specific Click on Download Here to download this MS Access Database

Printer friendly view