Session Information
Click here to go to the previous page
Easy End User Reporting for Finance using Microsoft Access (1161)
Track: Financial Management

Educatsional Expertise   Focus: Banner Finance
Program Code: 1161
LEAD PRESENTER / PANEL ORGANIZER / BOF LEADER :
Bob Siegfried, Director, Finance & Administrative Systems, Lehigh University
Description
Learn how Lehigh University provides over 400 end users on campus with desktop access to Banner financial data and reports using a Microsoft Access database. Since Lehigh has a Microsoft site license for the Office suite which includes Access, we determined this to be a very cost effective way to develop a uniform set of reports and provide easy access for campus users to run them as needed. The database is linked to a copy of our Banner production database that is updated every night (using Oracle tools) so the data is as current as the night before. The reporting database was created before the availability of ODS/EDW and uses baseline tables and views and a few custom views, but required no modifications to Banner Finance and uses basic fund org security maintained on FOMPROF. The presentation will include a demo of the actual database and the extensive menu of reports available to end users that have been developed since we went live with Banner Finance in July 2001, and how other schools can replicate this reporting database at their institutions.


Screen
(Code: 1161A/1161VA/1161)
Regular Attendee:Free
Virtual Attendee:Free
Authorized NON-Attendee:$25 USD
  
This session is a part of:
Handout Online
(Code: 1161A/1161VA/1161)
Regular Attendee:Free
Virtual Attendee:Free
Authorized NON-Attendee:Free
  
This session is a part of: