Undergraduate Students Graduating at University Park, Formerly at Another Campus (SYSIF147)

 Undergraduate Students Graduating at University Park, Formerly at Another Campus (SYSIF147)
This database is linked to the student database on the AIS Data Warehouse and contains two queries.  When completed, the final report will provide you with a list of undergraduate students who graduated from University Park during a specific semester that were once enrolled at a campus location you specify.

The first query (#1-qryUGStudentsGraduating) creates a table of all undergraduates approved to graduate from University Park during the semester you specify.  This query retrieves the student's name and social security number.

The second query compares the table of the University Park graduates (created from the first query) to the campus location you enter and creates a table of students that graduated at University Park but attended the campus location entered.  This query retrieves the student's name, social security number, and home address.

The final report, rptUGStudentsGraduatingFormerlyAtOtherLocation, is sorted alphabetically and contains a total count.

Start by selecting the QUERIES TAB, highlighting the query, #1-qryUGStudentsGraduating, and then select DESIGN.

Query #1

The first field you see will be code_univ_yr_sem.

 code_univ_yr_sem Field

For code_univ_yr_sem, you need to enter the semester the students graduated from University Park, for example:

199900SP = Spring 2000
200001FA = Fall 2000
200001SP = Spring 2001
200001SU = Summer 2001

Now that you have entered your criteria, close down the query and return to the query tab.  Highlight the query and select the OPEN button to the right.  This will run the query with the criteria you entered and produce a table, tblUGStudentsGraduating.  Once Access indicated it has finished running the query, return to the QUERIES tab so that you can run the next query.

Start the next query by selecting: 
#2 - qryUGStudentsGraduatingFormerlyAtOtherLocation and clicking on DESIGN.

Query #2 

Once you select DESIGN you will see the query in Design View.  Scroll to the right until you see the fields shown below.  You should now see the one field that requires you to enter criteria. This field is code_camp.

 code_camp Field 

For code_camp, you need to enter a campus code for the campus of the former campus location, for example:

BD = Behrend (Erie) Campus
DS = DuBois Campus
WS = Worthington-Scranton

Now that you have entered all of your criteria, close down the query and return to the query tab.  Highlight the query again and select the OPEN button to the right.  This will run the query with the criteria you entered and produce a table, tblUGStudentsGraduatingFormerlyAtOtherLocation.  Once Access indicated it has finished running the query, select REPORTS tab.  Highlight rptUGStudentsGraduatingFormerlyAtOtherLocation and select OPEN to view your report.

REPORT SAMPLE

Report Sample

This database is the following:
Semester Specific
Campus Specific

Click on Download Here to download this MS Access database.
Questions: AIS Support


 
Last revised: Thursday, June 29, 2006 15:33