Managing parking permits

Client: Patient Services
Platform: MS Access Web database integrated with SharePoint
Delivery Date: January 2015
Project Description: Department needs to accept online parking permit applications, process applications, assign and retract permits, and monitor expiration dates.
Features: Directors can access forms on SharePoint to request parking permits for their staff. Data macro notifies admin when a new application is entered. In back end, admin/manager can assign, retract, or inactivate permits; view unassigned permit numbers; track permit expiration dates; print report of new applications to present for approval; search for vehicles.
Users: 10

Web form page 1:
PCC-web-form-1

Web form page 2:
PCC-Vehicle-form

Back end user navigation:
back end user navigation

Manage permits:
PCC-manage-permits

Sample code, updates 3 tables when permit is assigned (click to enlarge):
PCC-code-sample

Sample code, updates 3 tables when permit is inactivated(click to enlarge):
PCC-code-sample-2

Phase 2: Add-on module to track parking violations, determine need for citation after multiple violations, track citation requests

Comments are closed.